PREVIEW / stock_30min / 2009-12-09

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-09.parquet
  size:    1.3 MB
  rows:    71,587
  symbols: 3,407

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-12-09 04:30:00	AAPL	Stock	6.7707	6.7707	6.7707	6.7707	2800.0
2009-12-09 05:00:00	AAPL	Stock	6.7654	6.7689	6.7632	6.7689	15400.0
2009-12-09 05:30:00	AAPL	Stock	6.7807	6.8036	6.7807	6.8036	11200.0
2009-12-09 06:00:00	AAPL	Stock	6.7996	6.7996	6.7996	6.7996	3920.0
2009-12-09 06:30:00	AAPL	Stock	6.8018	6.8018	6.8	6.8	5600.0
2009-12-09 07:00:00	AAPL	Stock	6.8075	6.8089	6.7993	6.8036	226380.0
2009-12-09 07:30:00	AAPL	Stock	6.7996	6.8371	6.7996	6.8229	565600.0
2009-12-09 08:00:00	AAPL	Stock	6.825	6.8536	6.8214	6.8436	3164000.0
2009-12-09 08:30:00	AAPL	Stock	6.8454	6.8464	6.8304	6.8393	1873592.0
2009-12-09 09:00:00	AAPL	Stock	6.84	6.845	6.8229	6.83	1815632.0
2009-12-09 09:30:00	AAPL	Stock	6.8296	6.8721	6.7968	6.8693	96095916.0
2009-12-09 10:00:00	AAPL	Stock	6.8696	6.885	6.8393	6.8611	60214980.0
2009-12-09 10:30:00	AAPL	Stock	6.8618	6.9136	6.8468	6.8971	60912460.0
2009-12-09 11:00:00	AAPL	Stock	6.8968	6.9129	6.8965	6.9027	26872692.0
2009-12-09 11:30:00	AAPL	Stock	6.9025	6.9089	6.8821	6.8918	25544624.0
2009-12-09 12:00:00	AAPL	Stock	6.8918	6.8964	6.8714	6.8775	22600004.0
2009-12-09 12:30:00	AAPL	Stock	6.8775	6.8964	6.8771	6.8954	14556248.0
2009-12-09 13:00:00	AAPL	Stock	6.8946	6.8993	6.8771	6.8982	21872704.0
2009-12-09 13:30:00	AAPL	Stock	6.8979	6.8996	6.875	6.8882	20119988.0
2009-12-09 14:00:00	AAPL	Stock	6.8882	6.9204	6.8821	6.91	32726092.0
2009-12-09 14:30:00	AAPL	Stock	6.9107	6.9625	6.9082	6.9582	51475648.0
2009-12-09 15:00:00	AAPL	Stock	6.9587	7.0321	6.9584	7.0171	103457088.0
2009-12-09 15:30:00	AAPL	Stock	7.0171	7.0771	7.0093	7.0518	112102284.0
2009-12-09 16:00:00	AAPL	Stock	7.0639	7.0699	6.9285	7.0596	10713136.0
2009-12-09 16:30:00	AAPL	Stock	7.0165	7.0643	7.0165	7.0643	444136.0
2009-12-09 17:00:00	AAPL	Stock	7.0643	7.0768	7.0643	7.0725	647388.0
2009-12-09 17:30:00	AAPL	Stock	7.0732	7.0757	6.841	7.0746	568372.0
2009-12-09 18:00:00	AAPL	Stock	7.075	7.0786	7.0643	7.075	1605716.0
2009-12-09 18:30:00	AAPL	Stock	7.0746	7.075	7.0684	7.0693	164836.0
2009-12-09 19:00:00	AAPL	Stock	7.0686	7.0729	7.0657	7.0657	310128.0
2009-12-09 19:30:00	AAPL	Stock	7.0657	7.0679	7.0618	7.0629	567840.0
2009-12-09 20:00:00	AAPL	Stock	6.8846	6.8846	6.8846	6.8846	11200.0
2009-12-09 07:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	400.0
2009-12-09 08:30:00	MSFT	Stock	29.63	29.7	29.62	29.7	14750.0
2009-12-09 09:00:00	MSFT	Stock	29.64	29.64	29.47	29.47	49526.0
2009-12-09 09:30:00	MSFT	Stock	29.46	29.48	29.25	29.43	7364925.0
2009-12-09 10:00:00	MSFT	Stock	29.43	29.45	29.35	29.438	2674892.0
2009-12-09 10:30:00	MSFT	Stock	29.432	29.77	29.41	29.745	5911974.0
2009-12-09 11:00:00	MSFT	Stock	29.745	29.81	29.67	29.695	4467275.0
2009-12-09 11:30:00	MSFT	Stock	29.7	29.7	29.63	29.65	1342780.0
2009-12-09 12:00:00	MSFT	Stock	29.65	29.7	29.58	29.59	2184423.0
2009-12-09 12:30:00	MSFT	Stock	29.59	29.655	29.56	29.642	1567769.0
2009-12-09 13:00:00	MSFT	Stock	29.64	29.75	29.6	29.64	1732900.0
2009-12-09 13:30:00	MSFT	Stock	29.638	29.65	29.56	29.61	1460572.0
2009-12-09 14:00:00	MSFT	Stock	29.61	29.67	29.6	29.63	1572488.0
2009-12-09 14:30:00	MSFT	Stock	29.632	29.68	29.61	29.638	1942871.0
2009-12-09 15:00:00	MSFT	Stock	29.64	29.77	29.64	29.72	3314704.0
2009-12-09 15:30:00	MSFT	Stock	29.73	29.8	29.71	29.71	5944698.0
2009-12-09 16:00:00	MSFT	Stock	29.72	29.748	29.6	29.604	2029302.0
2009-12-09 16:30:00	MSFT	Stock	29.714	29.74	29.604	29.74	76825.0

> showing 50 of 71,587 rows — these rows as CSV

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