PREVIEW / stock_30min / 2007-10-29

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-29.parquet
  size:    1.2 MB
  rows:    69,088
  symbols: 3,172

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
2007-10-29 06:30:00	AAPL	Stock	6.6607	6.6607	6.6607	6.6607	8708.0
2007-10-29 07:00:00	AAPL	Stock	6.6607	6.6607	6.6114	6.6114	137984.0
2007-10-29 07:30:00	AAPL	Stock	6.6496	6.6554	6.6429	6.6554	282016.0
2007-10-29 08:00:00	AAPL	Stock	6.6475	6.6518	6.6107	6.6107	2056124.0
2007-10-29 08:30:00	AAPL	Stock	6.6125	6.6161	6.5982	6.6068	2143232.0
2007-10-29 09:00:00	AAPL	Stock	6.6068	6.6389	6.6036	6.625	2349676.0
2007-10-29 09:30:00	AAPL	Stock	6.6232	6.6639	6.6107	6.6286	96972764.0
2007-10-29 10:00:00	AAPL	Stock	6.6275	6.6396	6.6	6.6186	65892456.0
2007-10-29 10:30:00	AAPL	Stock	6.6186	6.63	6.6057	6.6229	46067644.0
2007-10-29 11:00:00	AAPL	Stock	6.6218	6.6336	6.6157	6.6214	34067908.0
2007-10-29 11:30:00	AAPL	Stock	6.6211	6.625	6.6043	6.6119	34718012.0
2007-10-29 12:00:00	AAPL	Stock	6.6118	6.6214	6.5986	6.6086	32466672.0
2007-10-29 12:30:00	AAPL	Stock	6.6096	6.625	6.6	6.6204	29753052.0
2007-10-29 13:00:00	AAPL	Stock	6.6204	6.6214	6.6111	6.615	19037620.0
2007-10-29 13:30:00	AAPL	Stock	6.6143	6.6268	6.614	6.6252	20419896.0
2007-10-29 14:00:00	AAPL	Stock	6.6246	6.6304	6.6161	6.6161	25832100.0
2007-10-29 14:30:00	AAPL	Stock	6.6154	6.6196	6.6043	6.6167	34073060.0
2007-10-29 15:00:00	AAPL	Stock	6.6161	6.625	6.6071	6.6232	29357916.0
2007-10-29 15:30:00	AAPL	Stock	6.6232	6.6243	6.5964	6.6071	50087688.0
2007-10-29 16:00:00	AAPL	Stock	6.6089	6.6302	6.6046	6.6071	11914644.0
2007-10-29 16:30:00	AAPL	Stock	6.6068	6.6151	6.6068	6.6071	1716428.0
2007-10-29 17:00:00	AAPL	Stock	6.6036	6.6082	6.6036	6.6064	400232.0
2007-10-29 17:30:00	AAPL	Stock	6.6104	6.6197	6.6011	6.6166	311080.0
2007-10-29 18:00:00	AAPL	Stock	6.6166	6.6166	6.6011	6.6036	204400.0
2007-10-29 18:30:00	AAPL	Stock	6.6036	6.6054	6.6021	6.6036	83860.0
2007-10-29 19:00:00	AAPL	Stock	6.605	6.605	6.5964	6.6	147084.0
2007-10-29 19:30:00	AAPL	Stock	6.5971	6.6054	6.5971	6.6	54740.0
2007-10-29 05:30:00	MSFT	Stock	35.07	35.18	35.07	35.18	1300.0
2007-10-29 06:00:00	MSFT	Stock	35.18	35.18	35.18	35.18	180.0
2007-10-29 07:00:00	MSFT	Stock	35.2	35.25	35.12	35.12	8100.0
2007-10-29 07:30:00	MSFT	Stock	35.22	35.22	35.16	35.2	12800.0
2007-10-29 08:00:00	MSFT	Stock	35.21	35.34	35.15	35.24	55092.0
2007-10-29 08:30:00	MSFT	Stock	35.2	35.27	35.19	35.21	52330.0
2007-10-29 09:00:00	MSFT	Stock	35.21	35.23	34.8	34.87	753480.0
2007-10-29 09:30:00	MSFT	Stock	34.87	35.26	34.83	35.23	19498317.0
2007-10-29 10:00:00	MSFT	Stock	35.22	35.29	34.91	35.0	13309691.0
2007-10-29 10:30:00	MSFT	Stock	35.0	35.03	34.75	34.8	8562021.0
2007-10-29 11:00:00	MSFT	Stock	34.8	34.89	34.66	34.85	6753931.0
2007-10-29 11:30:00	MSFT	Stock	34.85	34.86	34.8	34.81	2826694.0
2007-10-29 12:00:00	MSFT	Stock	34.82	34.84	34.7	34.765	5172394.0
2007-10-29 12:30:00	MSFT	Stock	34.77	34.83	34.73	34.79	3383162.0
2007-10-29 13:00:00	MSFT	Stock	34.79	34.79	34.62	34.63	5036937.0
2007-10-29 13:30:00	MSFT	Stock	34.63	34.78	34.62	34.765	7124968.0
2007-10-29 14:00:00	MSFT	Stock	34.76	34.85	34.68	34.73	8955088.0
2007-10-29 14:30:00	MSFT	Stock	34.72	34.73	34.6	34.63	6209093.0
2007-10-29 15:00:00	MSFT	Stock	34.63	34.68	34.56	34.6	6154375.0
2007-10-29 15:30:00	MSFT	Stock	34.61	34.63	34.45	34.56	10284246.0
2007-10-29 16:00:00	MSFT	Stock	34.56	35.24	34.52	34.56	7021939.0
2007-10-29 16:30:00	MSFT	Stock	34.56	35.03	34.56	34.57	3642988.0
2007-10-29 17:00:00	MSFT	Stock	34.56	34.8	34.56	34.58	27173.0

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

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