PREVIEW / stock_30min / 2008-10-07

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-07.parquet
  size:    1.3 MB
  rows:    71,746
  symbols: 3,378

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-10-07 07:00:00	AAPL	Stock	3.5143	3.5625	3.5143	3.5464	139328.0
2008-10-07 07:30:00	AAPL	Stock	3.5393	3.5496	3.5232	3.5411	238000.0
2008-10-07 08:00:00	AAPL	Stock	3.5411	3.5411	3.4571	3.4643	3932684.0
2008-10-07 08:30:00	AAPL	Stock	3.4611	3.4925	3.425	3.4343	2812964.0
2008-10-07 09:00:00	AAPL	Stock	3.4343	3.5957	3.4343	3.5871	15715812.0
2008-10-07 09:30:00	AAPL	Stock	3.5871	3.625	3.3432	3.3654	247603356.0
2008-10-07 10:00:00	AAPL	Stock	3.3661	3.5	3.3232	3.4925	207594156.0
2008-10-07 10:30:00	AAPL	Stock	3.4932	3.5132	3.4054	3.4214	120898904.0
2008-10-07 11:00:00	AAPL	Stock	3.4214	3.4321	3.3793	3.3932	92675212.0
2008-10-07 11:30:00	AAPL	Stock	3.3936	3.4393	3.3754	3.4107	84399280.0
2008-10-07 12:00:00	AAPL	Stock	3.4111	3.4111	3.3289	3.3446	73999464.0
2008-10-07 12:30:00	AAPL	Stock	3.3464	3.3621	3.3089	3.3532	98348572.0
2008-10-07 13:00:00	AAPL	Stock	3.3529	3.4104	3.2964	3.3236	120304772.0
2008-10-07 13:30:00	AAPL	Stock	3.3207	3.3493	3.2589	3.2636	125514396.0
2008-10-07 14:00:00	AAPL	Stock	3.2632	3.3693	3.2568	3.3362	142958732.0
2008-10-07 14:30:00	AAPL	Stock	3.3371	3.3746	3.2736	3.2896	114720984.0
2008-10-07 15:00:00	AAPL	Stock	3.2896	3.3029	3.2157	3.27	148312052.0
2008-10-07 15:30:00	AAPL	Stock	3.27	3.2882	3.1768	3.1918	215807984.0
2008-10-07 16:00:00	AAPL	Stock	3.1846	3.4836	3.1761	3.1843	35651168.0
2008-10-07 16:30:00	AAPL	Stock	3.1893	3.2	3.1864	3.19	1340780.0
2008-10-07 17:00:00	AAPL	Stock	3.1936	3.1936	3.1821	3.1864	357532.0
2008-10-07 17:30:00	AAPL	Stock	3.1857	3.1868	3.1786	3.1868	418824.0
2008-10-07 18:00:00	AAPL	Stock	3.1857	3.1857	3.1782	3.1836	623420.0
2008-10-07 18:30:00	AAPL	Stock	3.1836	3.1857	3.1786	3.1839	671188.0
2008-10-07 19:00:00	AAPL	Stock	3.1796	3.1875	3.1786	3.1818	751688.0
2008-10-07 19:30:00	AAPL	Stock	3.1821	3.1875	3.1779	3.1786	1040564.0
2008-10-07 06:30:00	MSFT	Stock	24.91	24.91	24.91	24.91	1040.0
2008-10-07 07:00:00	MSFT	Stock	25.14	25.14	25.01	25.02	7158.0
2008-10-07 07:30:00	MSFT	Stock	25.02	25.1	24.99	25.05	6542.0
2008-10-07 08:00:00	MSFT	Stock	25.05	25.1	24.86	24.91	48229.0
2008-10-07 08:30:00	MSFT	Stock	24.95	24.95	24.55	24.6	50210.0
2008-10-07 09:00:00	MSFT	Stock	24.6	25.23	24.6	24.98	397623.0
2008-10-07 09:30:00	MSFT	Stock	24.98	25.21	24.47	24.55	12419280.0
2008-10-07 10:00:00	MSFT	Stock	24.55	24.7	24.37	24.5	10239414.0
2008-10-07 10:30:00	MSFT	Stock	24.49	24.58	24.31	24.345	7750555.0
2008-10-07 11:00:00	MSFT	Stock	24.35	24.35	24.04	24.09	8228027.0
2008-10-07 11:30:00	MSFT	Stock	24.09	24.3	24.085	24.27	7310173.0
2008-10-07 12:00:00	MSFT	Stock	24.27	24.33	24.05	24.075	5146579.0
2008-10-07 12:30:00	MSFT	Stock	24.08	24.13	23.97	24.062	7387666.0
2008-10-07 13:00:00	MSFT	Stock	24.06	24.31	23.75	23.78	9960874.0
2008-10-07 13:30:00	MSFT	Stock	23.8	23.94	23.55	23.56	9724758.0
2008-10-07 14:00:00	MSFT	Stock	23.56	24.16	23.54	23.97	12043408.0
2008-10-07 14:30:00	MSFT	Stock	23.99	24.21	23.78	23.8	9483969.0
2008-10-07 15:00:00	MSFT	Stock	23.8	23.95	23.63	23.78	9701063.0
2008-10-07 15:30:00	MSFT	Stock	23.77	23.82	23.14	23.16	19938439.0
2008-10-07 16:00:00	MSFT	Stock	23.2	24.89	23.11	23.17	11496394.0
2008-10-07 16:30:00	MSFT	Stock	23.23	23.718	23.18	23.19	374677.0
2008-10-07 17:00:00	MSFT	Stock	23.18	23.21	23.18	23.2	11898.0
2008-10-07 17:30:00	MSFT	Stock	23.17	23.23	23.16	23.22	7732.0
2008-10-07 18:00:00	MSFT	Stock	23.23	23.23	23.17	23.17	13041.0

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

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