PREVIEW / stock_30min / 2009-05-19

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-19.parquet
  size:    1.3 MB
  rows:    70,626
  symbols: 3,356

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-05-19 04:30:00	AAPL	Stock	4.5557	4.5768	4.5557	4.5618	25200.0
2009-05-19 05:30:00	AAPL	Stock	4.5786	4.5911	4.5786	4.5911	20916.0
2009-05-19 06:30:00	AAPL	Stock	4.5739	4.5871	4.5286	4.5871	102200.0
2009-05-19 07:00:00	AAPL	Stock	4.5646	4.5646	4.5625	4.5639	148036.0
2009-05-19 07:30:00	AAPL	Stock	4.5571	4.5639	4.5571	4.5607	30800.0
2009-05-19 08:00:00	AAPL	Stock	4.5607	4.5639	4.5493	4.5536	356832.0
2009-05-19 08:30:00	AAPL	Stock	4.5518	4.5571	4.5504	4.5518	782348.0
2009-05-19 09:00:00	AAPL	Stock	4.5518	4.5518	4.525	4.5279	760480.0
2009-05-19 09:30:00	AAPL	Stock	4.5293	4.55	4.4907	4.5307	70839888.0
2009-05-19 10:00:00	AAPL	Stock	4.53	4.5675	4.5275	4.5664	43987972.0
2009-05-19 10:30:00	AAPL	Stock	4.5675	4.5814	4.5611	4.5675	27920312.0
2009-05-19 11:00:00	AAPL	Stock	4.5679	4.5704	4.5479	4.5668	17376828.0
2009-05-19 11:30:00	AAPL	Stock	4.5675	4.5779	4.56	4.5711	17275720.0
2009-05-19 12:00:00	AAPL	Stock	4.5708	4.5982	4.5675	4.5954	17926384.0
2009-05-19 12:30:00	AAPL	Stock	4.5954	4.5957	4.5696	4.5725	18225032.0
2009-05-19 13:00:00	AAPL	Stock	4.5718	4.6036	4.5661	4.6025	20956964.0
2009-05-19 13:30:00	AAPL	Stock	4.6021	4.6075	4.5918	4.5991	18890368.0
2009-05-19 14:00:00	AAPL	Stock	4.5989	4.6104	4.5879	4.6068	16943920.0
2009-05-19 14:30:00	AAPL	Stock	4.6071	4.6182	4.5961	4.6043	20490372.0
2009-05-19 15:00:00	AAPL	Stock	4.6036	4.6096	4.5882	4.5964	21533036.0
2009-05-19 15:30:00	AAPL	Stock	4.5964	4.5974	4.5475	4.5525	42557984.0
2009-05-19 16:00:00	AAPL	Stock	4.5525	4.5884	4.5429	4.5486	8402016.0
2009-05-19 16:30:00	AAPL	Stock	4.5518	4.5518	4.5446	4.545	792484.0
2009-05-19 17:00:00	AAPL	Stock	4.5429	4.5479	4.5429	4.5479	110880.0
2009-05-19 17:30:00	AAPL	Stock	4.5482	4.5514	4.5482	4.5514	87108.0
2009-05-19 18:00:00	AAPL	Stock	4.5529	4.5554	4.5518	4.5543	342244.0
2009-05-19 18:30:00	AAPL	Stock	4.5571	4.5571	4.5571	4.5571	11200.0
2009-05-19 19:00:00	AAPL	Stock	4.5571	4.5571	4.5571	4.5571	11200.0
2009-05-19 19:30:00	AAPL	Stock	4.5561	4.5571	4.5536	4.5571	279440.0
2009-05-19 20:00:00	AAPL	Stock	4.57	4.57	4.5239	4.5239	159600.0
2009-05-19 04:00:00	MSFT	Stock	19.94	19.94	19.94	19.94	2000.0
2009-05-19 04:30:00	MSFT	Stock	20.61	20.61	20.61	20.61	250.0
2009-05-19 07:00:00	MSFT	Stock	20.5	20.5	20.5	20.5	1695.0
2009-05-19 08:00:00	MSFT	Stock	20.56	20.6	20.55	20.55	5651.0
2009-05-19 08:30:00	MSFT	Stock	20.5	20.5	20.46	20.47	3026.0
2009-05-19 09:00:00	MSFT	Stock	20.47	20.52	20.42	20.5	18440.0
2009-05-19 09:30:00	MSFT	Stock	20.5	20.54	20.3	20.44	5934632.0
2009-05-19 10:00:00	MSFT	Stock	20.43	20.67	20.41	20.64	4193876.0
2009-05-19 10:30:00	MSFT	Stock	20.65	20.74	20.61	20.63	3549780.0
2009-05-19 11:00:00	MSFT	Stock	20.62	20.655	20.51	20.525	2941084.0
2009-05-19 11:30:00	MSFT	Stock	20.54	20.56	20.46	20.46	1524292.0
2009-05-19 12:00:00	MSFT	Stock	20.46	20.51	20.46	20.486	1096610.0
2009-05-19 12:30:00	MSFT	Stock	20.489	20.52	20.46	20.51	1270931.0
2009-05-19 13:00:00	MSFT	Stock	20.51	20.6	20.51	20.59	1399152.0
2009-05-19 13:30:00	MSFT	Stock	20.59	20.61	20.55	20.551	2056965.0
2009-05-19 14:00:00	MSFT	Stock	20.558	20.57	20.47	20.472	2804011.0
2009-05-19 14:30:00	MSFT	Stock	20.48	20.53	20.42	20.423	3806935.0
2009-05-19 15:00:00	MSFT	Stock	20.43	20.47	20.39	20.45	4264218.0
2009-05-19 15:30:00	MSFT	Stock	20.45	20.45	20.25	20.31	8264403.0
2009-05-19 16:00:00	MSFT	Stock	20.31	20.477	20.226	20.31	2182048.0

> showing 50 of 70,626 rows — these rows as CSV

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