PREVIEW / stock_30min / 2009-12-01

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-01.parquet
  size:    1.4 MB
  rows:    73,837
  symbols: 3,441

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-01 04:00:00	AAPL	Stock	7.1664	7.175	7.1664	7.175	8400.0
2009-12-01 04:30:00	AAPL	Stock	7.1964	7.1964	7.1964	7.1964	2800.0
2009-12-01 05:30:00	AAPL	Stock	7.2036	7.2036	7.2036	7.2036	14000.0
2009-12-01 06:00:00	AAPL	Stock	7.2036	7.2036	7.2036	7.2036	12600.0
2009-12-01 07:00:00	AAPL	Stock	7.2029	7.2043	7.1971	7.1979	96656.0
2009-12-01 07:30:00	AAPL	Stock	7.1979	7.2007	7.1964	7.2	95900.0
2009-12-01 08:00:00	AAPL	Stock	7.1975	7.2182	7.1839	7.2096	2228912.0
2009-12-01 08:30:00	AAPL	Stock	7.2086	7.2121	7.1971	7.2061	865592.0
2009-12-01 09:00:00	AAPL	Stock	7.2057	7.2232	7.1396	7.2229	918456.0
2009-12-01 09:30:00	AAPL	Stock	7.2225	7.2418	7.2075	7.2221	60451020.0
2009-12-01 10:00:00	AAPL	Stock	7.22	7.2221	7.1614	7.17	58746324.0
2009-12-01 10:30:00	AAPL	Stock	7.17	7.1904	7.1689	7.1875	24676568.0
2009-12-01 11:00:00	AAPL	Stock	7.188	7.1982	7.1786	7.1793	22448636.0
2009-12-01 11:30:00	AAPL	Stock	7.1789	7.1893	7.1704	7.1864	14882644.0
2009-12-01 12:00:00	AAPL	Stock	7.1868	7.1961	7.1836	7.1846	12915420.0
2009-12-01 12:30:00	AAPL	Stock	7.1847	7.1925	7.1814	7.1875	11833612.0
2009-12-01 13:00:00	AAPL	Stock	7.1879	7.1993	7.1866	7.1943	15139012.0
2009-12-01 13:30:00	AAPL	Stock	7.1941	7.2004	7.1764	7.185	20197660.0
2009-12-01 14:00:00	AAPL	Stock	7.185	7.2018	7.185	7.2011	17472868.0
2009-12-01 14:30:00	AAPL	Stock	7.2011	7.2068	7.17	7.1746	25148760.0
2009-12-01 15:00:00	AAPL	Stock	7.1746	7.1982	7.1668	7.175	21099344.0
2009-12-01 15:30:00	AAPL	Stock	7.1746	7.175	7.0296	7.0325	130062688.0
2009-12-01 16:00:00	AAPL	Stock	7.0325	7.1624	7.0318	7.0704	19511940.0
2009-12-01 16:30:00	AAPL	Stock	7.0679	7.1567	7.0379	7.0661	932316.0
2009-12-01 17:00:00	AAPL	Stock	7.0661	7.0721	7.0643	7.0721	439544.0
2009-12-01 17:30:00	AAPL	Stock	7.075	7.0979	7.0714	7.0979	1204448.0
2009-12-01 18:00:00	AAPL	Stock	7.0975	7.1054	7.0929	7.1018	588140.0
2009-12-01 18:30:00	AAPL	Stock	7.1021	7.1107	7.0989	7.1	837312.0
2009-12-01 19:00:00	AAPL	Stock	7.0971	7.1036	7.0911	7.0929	528024.0
2009-12-01 19:30:00	AAPL	Stock	7.0929	7.0929	7.0786	7.0875	262388.0
2009-12-01 04:30:00	MSFT	Stock	29.57	29.57	29.57	29.57	200.0
2009-12-01 06:00:00	MSFT	Stock	29.59	29.59	29.59	29.59	200.0
2009-12-01 08:00:00	MSFT	Stock	29.51	29.61	29.48	29.6	6635.0
2009-12-01 08:30:00	MSFT	Stock	29.6	29.6	29.57	29.6	2552.0
2009-12-01 09:00:00	MSFT	Stock	29.6	29.6	29.41	29.52	19841.0
2009-12-01 09:30:00	MSFT	Stock	29.52	29.81	29.46	29.78	5253779.0
2009-12-01 10:00:00	MSFT	Stock	29.78	29.79	29.6	29.73	5816613.0
2009-12-01 10:30:00	MSFT	Stock	29.73	29.8	29.72	29.78	2854291.0
2009-12-01 11:00:00	MSFT	Stock	29.77	29.9	29.73	29.88	3621373.0
2009-12-01 11:30:00	MSFT	Stock	29.88	29.94	29.86	29.93	2692433.0
2009-12-01 12:00:00	MSFT	Stock	29.92	29.98	29.92	29.95	2287702.0
2009-12-01 12:30:00	MSFT	Stock	29.955	29.96	29.89	29.95	1630363.0
2009-12-01 13:00:00	MSFT	Stock	29.941	29.99	29.9	29.97	1547675.0
2009-12-01 13:30:00	MSFT	Stock	29.98	29.99	29.92	29.925	1835089.0
2009-12-01 14:00:00	MSFT	Stock	29.928	29.96	29.87	29.96	2599192.0
2009-12-01 14:30:00	MSFT	Stock	29.96	29.98	29.93	29.97	2671712.0
2009-12-01 15:00:00	MSFT	Stock	29.97	30.0	29.95	29.98	3828335.0
2009-12-01 15:30:00	MSFT	Stock	29.99	30.05	29.92	30.01	8105208.0
2009-12-01 16:00:00	MSFT	Stock	30.0	30.03	29.311	29.97	2748919.0
2009-12-01 16:30:00	MSFT	Stock	29.973	30.01	29.97	29.97	535500.0

> showing 50 of 73,837 rows — these rows as CSV

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