PREVIEW / stock_30min / 2008-02-22

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-22.parquet
  size:    1.2 MB
  rows:    68,916
  symbols: 3,267

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-02-22 04:00:00	AAPL	Stock	4.3554	4.3554	4.355	4.355	5600.0
2008-02-22 07:00:00	AAPL	Stock	4.3589	4.3589	4.3589	4.3589	2800.0
2008-02-22 07:30:00	AAPL	Stock	4.355	4.355	4.3461	4.3461	28000.0
2008-02-22 08:00:00	AAPL	Stock	4.3511	4.3646	4.3436	4.3568	2011352.0
2008-02-22 08:30:00	AAPL	Stock	4.3564	4.3686	4.3539	4.3607	1810844.0
2008-02-22 09:00:00	AAPL	Stock	4.3607	4.3746	4.3482	4.3746	2633988.0
2008-02-22 09:30:00	AAPL	Stock	4.3743	4.3754	4.3093	4.3294	123353608.0
2008-02-22 10:00:00	AAPL	Stock	4.3314	4.3336	4.2521	4.2611	163785328.0
2008-02-22 10:30:00	AAPL	Stock	4.2611	4.2761	4.2421	4.265	134270332.0
2008-02-22 11:00:00	AAPL	Stock	4.2646	4.2714	4.2429	4.2593	89602856.0
2008-02-22 11:30:00	AAPL	Stock	4.26	4.2804	4.2339	4.2425	87674580.0
2008-02-22 12:00:00	AAPL	Stock	4.2418	4.2429	4.21	4.2243	84863632.0
2008-02-22 12:30:00	AAPL	Stock	4.2246	4.2386	4.2154	4.2305	59279724.0
2008-02-22 13:00:00	AAPL	Stock	4.2306	4.2357	4.2004	4.2043	62002472.0
2008-02-22 13:30:00	AAPL	Stock	4.2036	4.2107	4.1829	4.185	95355092.0
2008-02-22 14:00:00	AAPL	Stock	4.185	4.1879	4.1646	4.1761	102331320.0
2008-02-22 14:30:00	AAPL	Stock	4.1751	4.2143	4.1732	4.2054	102908288.0
2008-02-22 15:00:00	AAPL	Stock	4.2046	4.21	4.1382	4.1682	148980384.0
2008-02-22 15:30:00	AAPL	Stock	4.1686	4.2661	4.1554	4.2643	244259652.0
2008-02-22 16:00:00	AAPL	Stock	4.2661	4.2829	4.2277	4.2736	21319424.0
2008-02-22 16:30:00	AAPL	Stock	4.2725	4.2807	4.2664	4.2714	2183636.0
2008-02-22 17:00:00	AAPL	Stock	4.2714	4.2746	4.2636	4.2725	862148.0
2008-02-22 17:30:00	AAPL	Stock	4.2725	4.2761	4.2682	4.2721	439348.0
2008-02-22 18:00:00	AAPL	Stock	4.2718	4.2725	4.2646	4.2654	386932.0
2008-02-22 18:30:00	AAPL	Stock	4.2675	4.2675	4.25	4.2625	205576.0
2008-02-22 19:00:00	AAPL	Stock	4.2675	4.2675	4.2571	4.2579	301700.0
2008-02-22 19:30:00	AAPL	Stock	4.2604	4.265	4.26	4.2621	454020.0
2008-02-22 08:00:00	MSFT	Stock	28.16	28.19	28.16	28.18	18000.0
2008-02-22 08:30:00	MSFT	Stock	28.18	28.25	28.18	28.22	61330.0
2008-02-22 09:00:00	MSFT	Stock	28.22	28.25	28.11	28.25	57848.0
2008-02-22 09:30:00	MSFT	Stock	28.21	28.39	28.12	28.2	8852953.0
2008-02-22 10:00:00	MSFT	Stock	28.2	28.2	27.93	28.03	8836597.0
2008-02-22 10:30:00	MSFT	Stock	28.04	28.06	27.88	27.9	7886283.0
2008-02-22 11:00:00	MSFT	Stock	27.898	27.93	27.67	27.68	7556273.0
2008-02-22 11:30:00	MSFT	Stock	27.68	27.69	27.55	27.63	8871373.0
2008-02-22 12:00:00	MSFT	Stock	27.64	27.64	27.2	27.55	14471746.0
2008-02-22 12:30:00	MSFT	Stock	27.55	27.65	27.48	27.58	4902699.0
2008-02-22 13:00:00	MSFT	Stock	27.58	27.6	27.45	27.57	5770408.0
2008-02-22 13:30:00	MSFT	Stock	27.56	27.66	27.49	27.65	6251416.0
2008-02-22 14:00:00	MSFT	Stock	27.65	27.76	27.6	27.66	8569114.0
2008-02-22 14:30:00	MSFT	Stock	27.65	27.76	27.56	27.72	9275491.0
2008-02-22 15:00:00	MSFT	Stock	27.72	27.76	27.56	27.65	11204164.0
2008-02-22 15:30:00	MSFT	Stock	27.65	27.76	27.54	27.73	18760331.0
2008-02-22 16:00:00	MSFT	Stock	27.719	27.76	27.635	27.7	4181289.0
2008-02-22 16:30:00	MSFT	Stock	27.7	27.7	27.68	27.7	141917.0
2008-02-22 17:00:00	MSFT	Stock	27.71	27.73	27.7	27.71	25400.0
2008-02-22 17:30:00	MSFT	Stock	27.7	27.72	27.7	27.71	17768.0
2008-02-22 18:00:00	MSFT	Stock	27.72	27.73	27.71	27.72	12208.0
2008-02-22 19:00:00	MSFT	Stock	27.71	27.71	27.71	27.71	3315.0
2008-02-22 19:30:00	MSFT	Stock	27.73	27.73	27.73	27.73	864.0

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

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