PREVIEW / stock_30min / 2010-03-11

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-11.parquet
  size:    1.4 MB
  rows:    72,465
  symbols: 3,461

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-03-11 05:00:00	AAPL	Stock	8.0618	8.0618	8.0618	8.0618	7000.0
2010-03-11 07:00:00	AAPL	Stock	8.0393	8.0429	8.0393	8.0429	5600.0
2010-03-11 07:30:00	AAPL	Stock	8.0329	8.0329	8.025	8.025	123312.0
2010-03-11 08:00:00	AAPL	Stock	8.025	8.0261	8.0129	8.02	325080.0
2010-03-11 08:30:00	AAPL	Stock	8.0196	8.0307	7.9889	8.0	1435448.0
2010-03-11 09:00:00	AAPL	Stock	7.9971	8.0061	7.9964	7.9968	746732.0
2010-03-11 09:30:00	AAPL	Stock	7.9968	8.0261	7.9757	7.9957	71823108.0
2010-03-11 10:00:00	AAPL	Stock	7.9961	8.0211	7.9957	8.0041	29950620.0
2010-03-11 10:30:00	AAPL	Stock	8.0041	8.0229	7.9936	8.0186	28792344.0
2010-03-11 11:00:00	AAPL	Stock	8.0188	8.0268	8.0061	8.0102	26967220.0
2010-03-11 11:30:00	AAPL	Stock	8.0114	8.0229	8.0	8.0221	18789708.0
2010-03-11 12:00:00	AAPL	Stock	8.0218	8.0218	7.9954	7.9971	25321772.0
2010-03-11 12:30:00	AAPL	Stock	7.9971	8.0161	7.9954	8.0129	14723296.0
2010-03-11 13:00:00	AAPL	Stock	8.0139	8.0168	8.0075	8.0137	10849496.0
2010-03-11 13:30:00	AAPL	Stock	8.0143	8.0204	8.0079	8.0125	15011388.0
2010-03-11 14:00:00	AAPL	Stock	8.0121	8.0136	7.9964	8.0009	20823796.0
2010-03-11 14:30:00	AAPL	Stock	8.0004	8.0143	7.9864	8.0107	25399388.0
2010-03-11 15:00:00	AAPL	Stock	8.0107	8.0432	8.0089	8.0414	46152764.0
2010-03-11 15:30:00	AAPL	Stock	8.0411	8.0536	8.0189	8.0536	50683220.0
2010-03-11 16:00:00	AAPL	Stock	8.0532	8.0561	8.0127	8.0536	8537592.0
2010-03-11 16:30:00	AAPL	Stock	8.0412	8.0571	8.0412	8.0554	439124.0
2010-03-11 17:00:00	AAPL	Stock	8.0568	8.0607	8.0511	8.0607	343448.0
2010-03-11 17:30:00	AAPL	Stock	8.0614	8.0614	8.0518	8.0536	169736.0
2010-03-11 18:00:00	AAPL	Stock	8.0539	8.0571	8.0429	8.0429	336252.0
2010-03-11 18:30:00	AAPL	Stock	8.0446	8.0482	8.0446	8.0464	89012.0
2010-03-11 19:00:00	AAPL	Stock	8.0471	8.05	8.045	8.0464	108276.0
2010-03-11 19:30:00	AAPL	Stock	8.0479	8.0514	8.0439	8.0446	140504.0
2010-03-11 06:00:00	MSFT	Stock	29.12	29.12	29.12	29.12	100.0
2010-03-11 08:00:00	MSFT	Stock	28.98	29.0	28.98	29.0	400.0
2010-03-11 08:30:00	MSFT	Stock	28.92	29.0	28.92	28.94	7770.0
2010-03-11 09:00:00	MSFT	Stock	28.9	28.98	28.87	28.97	18400.0
2010-03-11 09:30:00	MSFT	Stock	28.97	29.04	28.85	28.945	3479495.0
2010-03-11 10:00:00	MSFT	Stock	28.95	29.11	28.913	29.09	3778644.0
2010-03-11 10:30:00	MSFT	Stock	29.099	29.16	29.09	29.102	2330344.0
2010-03-11 11:00:00	MSFT	Stock	29.1	29.13	29.05	29.05	2201013.0
2010-03-11 11:30:00	MSFT	Stock	29.05	29.08	28.96	28.979	3355465.0
2010-03-11 12:00:00	MSFT	Stock	28.97	28.99	28.92	28.949	2715885.0
2010-03-11 12:30:00	MSFT	Stock	28.94	28.98	28.92	28.963	740428.0
2010-03-11 13:00:00	MSFT	Stock	28.965	29.02	28.94	28.995	961456.0
2010-03-11 13:30:00	MSFT	Stock	28.99	29.06	28.98	29.03	1588304.0
2010-03-11 14:00:00	MSFT	Stock	29.03	29.05	28.99	29.03	1454558.0
2010-03-11 14:30:00	MSFT	Stock	29.02	29.08	29.005	29.06	1655242.0
2010-03-11 15:00:00	MSFT	Stock	29.062	29.17	29.06	29.16	3744944.0
2010-03-11 15:30:00	MSFT	Stock	29.16	29.19	29.1	29.17	4791546.0
2010-03-11 16:00:00	MSFT	Stock	29.17	29.18	28.94	29.17	1428403.0
2010-03-11 16:30:00	MSFT	Stock	29.152	29.19	29.152	29.18	55905.0
2010-03-11 17:00:00	MSFT	Stock	29.18	29.18	29.18	29.18	918.0
2010-03-11 17:30:00	MSFT	Stock	29.18	29.18	29.18	29.18	572.0
2010-03-11 18:00:00	MSFT	Stock	29.15	29.18	29.14	29.18	1376.0
2010-03-11 19:00:00	MSFT	Stock	29.15	29.15	29.14	29.14	962.0

> showing 50 of 72,465 rows — these rows as CSV

> unlock the full archive -- $79 one-time