PREVIEW / stock_30min / 2008-02-25

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-25.parquet
  size:    1.2 MB
  rows:    68,772
  symbols: 3,266

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-25 04:00:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	5600.0
2008-02-25 05:30:00	AAPL	Stock	4.2857	4.2857	4.2829	4.2836	38780.0
2008-02-25 06:00:00	AAPL	Stock	4.2804	4.2804	4.2718	4.2718	22400.0
2008-02-25 06:30:00	AAPL	Stock	4.2793	4.2857	4.2789	4.2857	16800.0
2008-02-25 07:00:00	AAPL	Stock	4.2789	4.2811	4.2789	4.2804	8400.0
2008-02-25 07:30:00	AAPL	Stock	4.2782	4.2786	4.2571	4.2571	243600.0
2008-02-25 08:00:00	AAPL	Stock	4.2732	4.2732	4.225	4.2375	4159512.0
2008-02-25 08:30:00	AAPL	Stock	4.2361	4.2411	4.2304	4.2375	1242500.0
2008-02-25 09:00:00	AAPL	Stock	4.2375	4.245	4.2339	4.2361	2293536.0
2008-02-25 09:30:00	AAPL	Stock	4.2354	4.2918	4.2029	4.2036	168416584.0
2008-02-25 10:00:00	AAPL	Stock	4.2036	4.2675	4.185	4.2643	165458552.0
2008-02-25 10:30:00	AAPL	Stock	4.2642	4.2736	4.2339	4.2421	103272428.0
2008-02-25 11:00:00	AAPL	Stock	4.2418	4.2468	4.2254	4.2306	60899972.0
2008-02-25 11:30:00	AAPL	Stock	4.2304	4.2325	4.2093	4.2129	56485576.0
2008-02-25 12:00:00	AAPL	Stock	4.2121	4.2307	4.2043	4.2064	58560628.0
2008-02-25 12:30:00	AAPL	Stock	4.2068	4.2211	4.1964	4.2136	41007988.0
2008-02-25 13:00:00	AAPL	Stock	4.2136	4.2175	4.1811	4.1868	50062096.0
2008-02-25 13:30:00	AAPL	Stock	4.1868	4.2071	4.1666	4.1846	63991032.0
2008-02-25 14:00:00	AAPL	Stock	4.1836	4.2336	4.1696	4.2304	73645600.0
2008-02-25 14:30:00	AAPL	Stock	4.2311	4.2554	4.1789	4.2025	115512600.0
2008-02-25 15:00:00	AAPL	Stock	4.2014	4.2314	4.1889	4.2243	98374640.0
2008-02-25 15:30:00	AAPL	Stock	4.2239	4.2804	4.2157	4.2707	159508076.0
2008-02-25 16:00:00	AAPL	Stock	4.2696	4.2804	4.2238	4.227	30878988.0
2008-02-25 16:30:00	AAPL	Stock	4.2725	4.2764	4.2114	4.2679	862344.0
2008-02-25 17:00:00	AAPL	Stock	4.2679	4.2764	4.2643	4.2679	531048.0
2008-02-25 17:30:00	AAPL	Stock	4.2679	4.2711	4.2679	4.2679	185248.0
2008-02-25 18:00:00	AAPL	Stock	4.2654	4.2714	4.2643	4.2675	398020.0
2008-02-25 18:30:00	AAPL	Stock	4.2639	4.2668	4.2607	4.2607	249480.0
2008-02-25 19:00:00	AAPL	Stock	4.2632	4.2632	4.2518	4.2607	281148.0
2008-02-25 19:30:00	AAPL	Stock	4.2607	4.2654	4.2607	4.2654	203364.0
2008-02-25 06:30:00	MSFT	Stock	27.75	27.85	27.75	27.85	1400.0
2008-02-25 07:00:00	MSFT	Stock	27.74	27.77	27.74	27.77	1400.0
2008-02-25 07:30:00	MSFT	Stock	27.74	27.74	27.74	27.74	1000.0
2008-02-25 08:00:00	MSFT	Stock	27.74	27.77	27.55	27.6	79279.0
2008-02-25 08:30:00	MSFT	Stock	27.64	27.65	27.61	27.64	5110.0
2008-02-25 09:00:00	MSFT	Stock	27.65	27.7	27.59	27.59	57142.0
2008-02-25 09:30:00	MSFT	Stock	27.59	27.98	27.48	27.91	11950130.0
2008-02-25 10:00:00	MSFT	Stock	27.91	28.21	27.91	28.2	12650585.0
2008-02-25 10:30:00	MSFT	Stock	28.21	28.24	27.94	27.95	8459359.0
2008-02-25 11:00:00	MSFT	Stock	27.96	28.01	27.85	27.92	4307433.0
2008-02-25 11:30:00	MSFT	Stock	27.91	27.92	27.65	27.67	5577259.0
2008-02-25 12:00:00	MSFT	Stock	27.67	27.71	27.6	27.61	4595415.0
2008-02-25 12:30:00	MSFT	Stock	27.62	27.72	27.58	27.698	4972109.0
2008-02-25 13:00:00	MSFT	Stock	27.7	27.79	27.62	27.63	4204022.0
2008-02-25 13:30:00	MSFT	Stock	27.62	27.7	27.6	27.68	3683727.0
2008-02-25 14:00:00	MSFT	Stock	27.69	27.9	27.66	27.89	6138635.0
2008-02-25 14:30:00	MSFT	Stock	27.89	27.96	27.8	27.91	18549760.0
2008-02-25 15:00:00	MSFT	Stock	27.91	27.96	27.8	27.89	9602633.0
2008-02-25 15:30:00	MSFT	Stock	27.89	27.93	27.82	27.82	12607050.0
2008-02-25 16:00:00	MSFT	Stock	27.82	27.872	27.728	27.84	2447699.0

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

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