PREVIEW / stock_30min / 2010-01-19

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-19.parquet
  size:    1.4 MB
  rows:    74,649
  symbols: 3,467

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-01-19 04:00:00	AAPL	Stock	7.4446	7.4446	7.42	7.4214	8400.0
2010-01-19 04:30:00	AAPL	Stock	7.4286	7.4289	7.4286	7.4289	10220.0
2010-01-19 05:00:00	AAPL	Stock	7.42	7.42	7.3982	7.4114	18620.0
2010-01-19 05:30:00	AAPL	Stock	7.4057	7.4057	7.4057	7.4057	5600.0
2010-01-19 06:00:00	AAPL	Stock	7.4057	7.4139	7.4021	7.4139	40628.0
2010-01-19 06:30:00	AAPL	Stock	7.4021	7.4021	7.4021	7.4021	8400.0
2010-01-19 07:00:00	AAPL	Stock	7.4154	7.4154	7.4011	7.4057	74200.0
2010-01-19 07:30:00	AAPL	Stock	7.4007	7.4386	7.4007	7.4093	447776.0
2010-01-19 08:00:00	AAPL	Stock	7.4107	7.4161	7.3546	7.3989	1830192.0
2010-01-19 08:30:00	AAPL	Stock	7.4	7.4286	7.3929	7.415	1964760.0
2010-01-19 09:00:00	AAPL	Stock	7.4096	7.4429	7.3957	7.4404	1574692.0
2010-01-19 09:30:00	AAPL	Stock	7.4418	7.5368	7.4014	7.5268	102260088.0
2010-01-19 10:00:00	AAPL	Stock	7.5268	7.5621	7.5268	7.5511	68179944.0
2010-01-19 10:30:00	AAPL	Stock	7.5511	7.5954	7.5471	7.5796	54383084.0
2010-01-19 11:00:00	AAPL	Stock	7.58	7.6068	7.5768	7.6064	39049024.0
2010-01-19 11:30:00	AAPL	Stock	7.6043	7.6279	7.6043	7.6147	45012632.0
2010-01-19 12:00:00	AAPL	Stock	7.6146	7.6486	7.6146	7.6293	44614192.0
2010-01-19 12:30:00	AAPL	Stock	7.6286	7.6518	7.6268	7.6382	33830664.0
2010-01-19 13:00:00	AAPL	Stock	7.6375	7.6496	7.6214	7.6461	31468220.0
2010-01-19 13:30:00	AAPL	Stock	7.6461	7.6639	7.6396	7.6575	57997828.0
2010-01-19 14:00:00	AAPL	Stock	7.6572	7.6671	7.648	7.6664	28278264.0
2010-01-19 14:30:00	AAPL	Stock	7.6653	7.6679	7.6521	7.6625	24325504.0
2010-01-19 15:00:00	AAPL	Stock	7.6618	7.675	7.6486	7.6726	42733824.0
2010-01-19 15:30:00	AAPL	Stock	7.6725	7.6854	7.6639	7.68	74164048.0
2010-01-19 16:00:00	AAPL	Stock	7.6825	7.6946	7.5315	7.6604	16190300.0
2010-01-19 16:30:00	AAPL	Stock	7.5812	7.6798	7.5812	7.6564	1448748.0
2010-01-19 17:00:00	AAPL	Stock	7.6557	7.68	7.3577	7.65	4180260.0
2010-01-19 17:30:00	AAPL	Stock	7.6482	7.6554	7.6482	7.6521	289408.0
2010-01-19 18:00:00	AAPL	Stock	7.6518	7.68	7.6518	7.6564	355824.0
2010-01-19 18:30:00	AAPL	Stock	7.6536	7.6571	7.6518	7.6571	88340.0
2010-01-19 19:00:00	AAPL	Stock	7.6611	7.6611	7.6555	7.6607	130592.0
2010-01-19 19:30:00	AAPL	Stock	7.6559	7.6625	7.6518	7.6579	341460.0
2010-01-19 06:30:00	MSFT	Stock	30.72	30.74	30.72	30.74	2000.0
2010-01-19 07:00:00	MSFT	Stock	30.65	30.72	30.63	30.65	12802.0
2010-01-19 07:30:00	MSFT	Stock	30.66	30.66	30.53	30.65	4865.0
2010-01-19 08:00:00	MSFT	Stock	30.68	30.86	30.57	30.66	144903.0
2010-01-19 08:30:00	MSFT	Stock	30.66	30.72	30.57	30.72	9487.0
2010-01-19 09:00:00	MSFT	Stock	30.72	30.75	30.68	30.73	23045.0
2010-01-19 09:30:00	MSFT	Stock	30.74	31.15	30.68	31.02	5784716.0
2010-01-19 10:00:00	MSFT	Stock	31.01	31.17	30.97	31.06	4760484.0
2010-01-19 10:30:00	MSFT	Stock	31.05	31.2	31.05	31.18	3012488.0
2010-01-19 11:00:00	MSFT	Stock	31.178	31.18	31.11	31.12	1949449.0
2010-01-19 11:30:00	MSFT	Stock	31.12	31.15	31.02	31.04	2537397.0
2010-01-19 12:00:00	MSFT	Stock	31.04	31.16	31.035	31.16	1602819.0
2010-01-19 12:30:00	MSFT	Stock	31.155	31.19	31.14	31.17	1139122.0
2010-01-19 13:00:00	MSFT	Stock	31.17	31.19	31.1	31.17	1634619.0
2010-01-19 13:30:00	MSFT	Stock	31.17	31.19	31.13	31.19	1584394.0
2010-01-19 14:00:00	MSFT	Stock	31.18	31.24	31.18	31.21	3081077.0
2010-01-19 14:30:00	MSFT	Stock	31.22	31.22	31.06	31.11	2065700.0
2010-01-19 15:00:00	MSFT	Stock	31.11	31.13	31.04	31.12	4301832.0

> showing 50 of 74,649 rows — these rows as CSV

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