PREVIEW / stock_30min / 2009-01-16

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-16.parquet
  size:    1.2 MB
  rows:    69,048
  symbols: 3,309

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
2009-01-16 05:00:00	AAPL	Stock	3.0336	3.0336	3.0336	3.0336	2800.0
2009-01-16 06:30:00	AAPL	Stock	3.0318	3.0336	3.0318	3.0336	11200.0
2009-01-16 07:00:00	AAPL	Stock	3.0246	3.0275	3.0143	3.0179	34328.0
2009-01-16 07:30:00	AAPL	Stock	3.0214	3.025	2.9993	3.0	162400.0
2009-01-16 08:00:00	AAPL	Stock	3.0	3.01	2.9929	2.9979	689584.0
2009-01-16 08:30:00	AAPL	Stock	2.9996	3.0036	2.9911	2.9961	1176420.0
2009-01-16 09:00:00	AAPL	Stock	2.9961	3.0107	2.9961	3.01	1121232.0
2009-01-16 09:30:00	AAPL	Stock	3.0104	3.0136	2.9161	2.9175	161470316.0
2009-01-16 10:00:00	AAPL	Stock	2.9175	2.9282	2.8771	2.8957	112266504.0
2009-01-16 10:30:00	AAPL	Stock	2.8954	2.9107	2.8861	2.8918	73027752.0
2009-01-16 11:00:00	AAPL	Stock	2.8921	2.9025	2.8714	2.8975	64138592.0
2009-01-16 11:30:00	AAPL	Stock	2.8982	2.9067	2.88	2.9021	56777028.0
2009-01-16 12:00:00	AAPL	Stock	2.9021	2.9064	2.8714	2.8761	55103720.0
2009-01-16 12:30:00	AAPL	Stock	2.8764	2.9014	2.8743	2.8982	36363012.0
2009-01-16 13:00:00	AAPL	Stock	2.8982	2.905	2.8789	2.89	43821932.0
2009-01-16 13:30:00	AAPL	Stock	2.89	2.9125	2.8846	2.9011	56887768.0
2009-01-16 14:00:00	AAPL	Stock	2.9014	2.9189	2.8936	2.9139	58262064.0
2009-01-16 14:30:00	AAPL	Stock	2.9139	2.9296	2.9064	2.9254	62894776.0
2009-01-16 15:00:00	AAPL	Stock	2.925	2.9375	2.8864	2.8957	70460796.0
2009-01-16 15:30:00	AAPL	Stock	2.8964	2.95	2.8882	2.94	148680056.0
2009-01-16 16:00:00	AAPL	Stock	2.9404	2.9464	2.9096	2.9407	30403716.0
2009-01-16 16:30:00	AAPL	Stock	2.9404	2.9439	2.9296	2.9307	1351308.0
2009-01-16 17:00:00	AAPL	Stock	2.9339	2.9343	2.9157	2.9232	236600.0
2009-01-16 17:30:00	AAPL	Stock	2.9236	2.9286	2.9236	2.9286	346780.0
2009-01-16 18:00:00	AAPL	Stock	2.9286	2.9286	2.925	2.9279	309176.0
2009-01-16 18:30:00	AAPL	Stock	2.9268	2.9268	2.9214	2.9214	14700.0
2009-01-16 19:00:00	AAPL	Stock	2.9268	2.9343	2.9268	2.9343	326340.0
2009-01-16 19:30:00	AAPL	Stock	2.9343	2.9439	2.9343	2.9393	501592.0
2009-01-16 07:00:00	MSFT	Stock	19.64	19.64	19.64	19.64	100.0
2009-01-16 07:30:00	MSFT	Stock	19.52	19.59	19.5	19.59	7098.0
2009-01-16 08:00:00	MSFT	Stock	19.51	19.6	19.51	19.53	32455.0
2009-01-16 08:30:00	MSFT	Stock	19.53	19.57	19.53	19.55	16417.0
2009-01-16 09:00:00	MSFT	Stock	19.55	19.58	19.51	19.58	18755.0
2009-01-16 09:30:00	MSFT	Stock	19.6	19.91	19.59	19.72	15988072.0
2009-01-16 10:00:00	MSFT	Stock	19.72	19.78	19.51	19.51	6594318.0
2009-01-16 10:30:00	MSFT	Stock	19.51	19.7	19.48	19.55	4690817.0
2009-01-16 11:00:00	MSFT	Stock	19.552	19.7	19.42	19.55	3553914.0
2009-01-16 11:30:00	MSFT	Stock	19.55	19.58	19.32	19.38	3820411.0
2009-01-16 12:00:00	MSFT	Stock	19.38	19.7	19.15	19.23	3556254.0
2009-01-16 12:30:00	MSFT	Stock	19.225	19.34	19.198	19.32	3453547.0
2009-01-16 13:00:00	MSFT	Stock	19.325	19.35	19.23	19.32	2715806.0
2009-01-16 13:30:00	MSFT	Stock	19.32	19.43	19.26	19.41	2610569.0
2009-01-16 14:00:00	MSFT	Stock	19.41	19.51	19.35	19.42	2980441.0
2009-01-16 14:30:00	MSFT	Stock	19.41	19.58	19.36	19.58	3861359.0
2009-01-16 15:00:00	MSFT	Stock	19.575	19.73	19.55	19.58	6908958.0
2009-01-16 15:30:00	MSFT	Stock	19.58	19.78	19.56	19.72	11270168.0
2009-01-16 16:00:00	MSFT	Stock	19.72	19.73	19.514	19.71	5283843.0
2009-01-16 16:30:00	MSFT	Stock	19.71	19.71	19.64	19.64	86833.0
2009-01-16 17:00:00	MSFT	Stock	19.65	19.7	19.65	19.65	1500.0
2009-01-16 17:30:00	MSFT	Stock	19.71	19.72	19.71	19.71	4550.0

> showing 50 of 69,048 rows — these rows as CSV

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