PREVIEW / stock_30min / 2008-05-20

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-20.parquet
  size:    1.3 MB
  rows:    68,813
  symbols: 3,318

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
2008-05-20 05:30:00	AAPL	Stock	6.5661	6.5661	6.5614	6.5614	11200.0
2008-05-20 06:00:00	AAPL	Stock	6.5711	6.5711	6.5711	6.5711	5600.0
2008-05-20 06:30:00	AAPL	Stock	6.5539	6.5539	6.5539	6.5539	8400.0
2008-05-20 07:00:00	AAPL	Stock	6.5182	6.5182	6.5182	6.5182	11088.0
2008-05-20 07:30:00	AAPL	Stock	6.5446	6.5446	6.5275	6.5357	50400.0
2008-05-20 08:00:00	AAPL	Stock	6.5304	6.5621	6.5268	6.5357	1868664.0
2008-05-20 08:30:00	AAPL	Stock	6.5404	6.5425	6.5018	6.5057	3045728.0
2008-05-20 09:00:00	AAPL	Stock	6.5054	6.5143	6.4911	6.4943	3722600.0
2008-05-20 09:30:00	AAPL	Stock	6.4929	6.5779	6.4329	6.5324	164032428.0
2008-05-20 10:00:00	AAPL	Stock	6.5318	6.5821	6.5204	6.5768	92478960.0
2008-05-20 10:30:00	AAPL	Stock	6.5768	6.5868	6.5036	6.5843	83504092.0
2008-05-20 11:00:00	AAPL	Stock	6.5843	6.5893	6.5357	6.5779	64099784.0
2008-05-20 11:30:00	AAPL	Stock	6.5775	6.5875	6.5532	6.5736	37321592.0
2008-05-20 12:00:00	AAPL	Stock	6.5736	6.6357	6.565	6.6204	62460468.0
2008-05-20 12:30:00	AAPL	Stock	6.62	6.6382	6.5889	6.6018	40812548.0
2008-05-20 13:00:00	AAPL	Stock	6.6018	6.625	6.5839	6.5957	31351964.0
2008-05-20 13:30:00	AAPL	Stock	6.595	6.5982	6.5375	6.5393	49806596.0
2008-05-20 14:00:00	AAPL	Stock	6.5389	6.5846	6.5261	6.5839	60235224.0
2008-05-20 14:30:00	AAPL	Stock	6.5839	6.6243	6.5771	6.5907	67005932.0
2008-05-20 15:00:00	AAPL	Stock	6.5918	6.6454	6.5768	6.6339	68958316.0
2008-05-20 15:30:00	AAPL	Stock	6.6339	6.6486	6.5771	6.6411	112026740.0
2008-05-20 16:00:00	AAPL	Stock	6.6449	6.6457	6.5709	6.6375	9684668.0
2008-05-20 16:30:00	AAPL	Stock	6.6389	6.6393	6.5715	6.6389	348656.0
2008-05-20 17:00:00	AAPL	Stock	6.6375	6.6429	6.6368	6.6379	119112.0
2008-05-20 17:30:00	AAPL	Stock	6.6375	6.6379	6.6139	6.6243	564284.0
2008-05-20 18:00:00	AAPL	Stock	6.6243	6.6243	6.6214	6.6243	145880.0
2008-05-20 18:30:00	AAPL	Stock	6.6232	6.6321	6.6229	6.6321	89712.0
2008-05-20 19:00:00	AAPL	Stock	6.6304	6.6304	6.6218	6.6229	85960.0
2008-05-20 19:30:00	AAPL	Stock	6.6218	6.6275	6.6218	6.625	114660.0
2008-05-20 08:00:00	MSFT	Stock	29.46	29.5	29.36	29.41	7952.0
2008-05-20 08:30:00	MSFT	Stock	29.43	29.46	29.41	29.42	25942.0
2008-05-20 09:00:00	MSFT	Stock	29.41	29.43	29.28	29.3	32034.0
2008-05-20 09:30:00	MSFT	Stock	29.3	29.31	29.01	29.01	5695075.0
2008-05-20 10:00:00	MSFT	Stock	29.01	29.02	28.87	28.97	8217775.0
2008-05-20 10:30:00	MSFT	Stock	28.96	28.99	28.9	28.99	4386371.0
2008-05-20 11:00:00	MSFT	Stock	28.99	29.05	28.82	28.9	5696600.0
2008-05-20 11:30:00	MSFT	Stock	28.89	29.03	28.63	28.728	7201785.0
2008-05-20 12:00:00	MSFT	Stock	28.72	28.79	28.64	28.76	6314298.0
2008-05-20 12:30:00	MSFT	Stock	28.76	28.85	28.7	28.76	3225743.0
2008-05-20 13:00:00	MSFT	Stock	28.76	28.88	28.73	28.87	3466284.0
2008-05-20 13:30:00	MSFT	Stock	28.88	28.92	28.82	28.82	5167103.0
2008-05-20 14:00:00	MSFT	Stock	28.82	28.91	28.82	28.85	3168593.0
2008-05-20 14:30:00	MSFT	Stock	28.842	28.96	28.756	28.89	4074879.0
2008-05-20 15:00:00	MSFT	Stock	28.89	28.98	28.88	28.892	4378451.0
2008-05-20 15:30:00	MSFT	Stock	28.89	28.9	28.737	28.77	11349205.0
2008-05-20 16:00:00	MSFT	Stock	28.79	29.275	28.76	28.8	2310675.0
2008-05-20 16:30:00	MSFT	Stock	28.79	28.873	28.76	28.76	49417.0
2008-05-20 17:00:00	MSFT	Stock	28.79	28.79	28.75	28.76	18047.0
2008-05-20 17:30:00	MSFT	Stock	28.76	28.84	28.76	28.77	116141.0
2008-05-20 18:00:00	MSFT	Stock	28.83	28.83	28.8	28.82	500.0

> showing 50 of 68,813 rows — these rows as CSV

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