PREVIEW / stock_30min / 2009-04-15

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-15.parquet
  size:    1.2 MB
  rows:    69,144
  symbols: 3,308

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-04-15 07:00:00	AAPL	Stock	4.2054	4.2071	4.2054	4.2071	86800.0
2009-04-15 07:30:00	AAPL	Stock	4.2018	4.2029	4.2018	4.2018	28000.0
2009-04-15 08:00:00	AAPL	Stock	4.1971	4.1971	4.1893	4.1911	111468.0
2009-04-15 08:30:00	AAPL	Stock	4.2025	4.2025	4.1814	4.1825	271768.0
2009-04-15 09:00:00	AAPL	Stock	4.1839	4.1925	4.175	4.1793	410200.0
2009-04-15 09:30:00	AAPL	Stock	4.1818	4.2086	4.1714	4.2007	55719216.0
2009-04-15 10:00:00	AAPL	Stock	4.2011	4.2232	4.1893	4.1979	33908168.0
2009-04-15 10:30:00	AAPL	Stock	4.1984	4.2	4.1536	4.1554	27636616.0
2009-04-15 11:00:00	AAPL	Stock	4.1554	4.1564	4.1343	4.1443	32578980.0
2009-04-15 11:30:00	AAPL	Stock	4.1443	4.1671	4.1443	4.1579	19411616.0
2009-04-15 12:00:00	AAPL	Stock	4.1578	4.1668	4.1504	4.1518	16871736.0
2009-04-15 12:30:00	AAPL	Stock	4.1514	4.1611	4.1504	4.1554	13165824.0
2009-04-15 13:00:00	AAPL	Stock	4.1554	4.2018	4.1549	4.1961	32673984.0
2009-04-15 13:30:00	AAPL	Stock	4.1964	4.2	4.175	4.1786	19709088.0
2009-04-15 14:00:00	AAPL	Stock	4.1786	4.1918	4.1579	4.1614	26466328.0
2009-04-15 14:30:00	AAPL	Stock	4.1618	4.1679	4.145	4.1546	26923820.0
2009-04-15 15:00:00	AAPL	Stock	4.1543	4.1793	4.1532	4.1646	34783644.0
2009-04-15 15:30:00	AAPL	Stock	4.1643	4.2079	4.1593	4.1979	55834240.0
2009-04-15 16:00:00	AAPL	Stock	4.2025	4.2071	4.173	4.2029	12469632.0
2009-04-15 16:30:00	AAPL	Stock	4.2032	4.2036	4.2	4.2029	89264.0
2009-04-15 17:00:00	AAPL	Stock	4.2018	4.2039	4.1982	4.2025	55720.0
2009-04-15 17:30:00	AAPL	Stock	4.2018	4.2054	4.2018	4.2054	46312.0
2009-04-15 18:00:00	AAPL	Stock	4.2014	4.2136	4.2014	4.2136	250124.0
2009-04-15 18:30:00	AAPL	Stock	4.2107	4.2107	4.2082	4.2082	34860.0
2009-04-15 19:00:00	AAPL	Stock	4.2121	4.2121	4.2107	4.2107	39200.0
2009-04-15 19:30:00	AAPL	Stock	4.2121	4.2125	4.2107	4.2107	53200.0
2009-04-15 04:30:00	MSFT	Stock	19.11	19.11	19.11	19.11	250.0
2009-04-15 07:00:00	MSFT	Stock	19.26	19.3	19.06	19.09	19100.0
2009-04-15 07:30:00	MSFT	Stock	19.1	19.1	19.1	19.1	2000.0
2009-04-15 08:00:00	MSFT	Stock	19.08	19.15	19.08	19.15	8290.0
2009-04-15 08:30:00	MSFT	Stock	19.17	19.28	19.15	19.2	26735.0
2009-04-15 09:00:00	MSFT	Stock	19.2	19.25	19.14	19.21	21591.0
2009-04-15 09:30:00	MSFT	Stock	19.21	19.26	18.61	18.81	11526899.0
2009-04-15 10:00:00	MSFT	Stock	18.81	18.95	18.77	18.95	6543641.0
2009-04-15 10:30:00	MSFT	Stock	18.94	18.99	18.61	18.61	6449799.0
2009-04-15 11:00:00	MSFT	Stock	18.61	18.66	18.51	18.59	5513994.0
2009-04-15 11:30:00	MSFT	Stock	18.6	18.73	18.58	18.71	3920096.0
2009-04-15 12:00:00	MSFT	Stock	18.71	18.74	18.66	18.68	3318442.0
2009-04-15 12:30:00	MSFT	Stock	18.69	18.89	18.68	18.85	2512672.0
2009-04-15 13:00:00	MSFT	Stock	18.85	18.92	18.83	18.9	3779628.0
2009-04-15 13:30:00	MSFT	Stock	18.9	18.92	18.8	18.92	2262214.0
2009-04-15 14:00:00	MSFT	Stock	18.92	18.92	18.69	18.73	4223008.0
2009-04-15 14:30:00	MSFT	Stock	18.74	18.802	18.52	18.6	4756740.0
2009-04-15 15:00:00	MSFT	Stock	18.61	18.782	18.6	18.7	5861918.0
2009-04-15 15:30:00	MSFT	Stock	18.69	18.9	18.64	18.85	8635417.0
2009-04-15 16:00:00	MSFT	Stock	18.85	18.88	18.666	18.83	2258162.0
2009-04-15 16:30:00	MSFT	Stock	18.83	18.9	18.83	18.85	110714.0
2009-04-15 17:00:00	MSFT	Stock	18.88	18.9	18.88	18.9	2263.0
2009-04-15 17:30:00	MSFT	Stock	18.88	18.9	18.86	18.9	2950.0
2009-04-15 18:00:00	MSFT	Stock	18.83	18.91	18.83	18.9	210009.0

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

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