PREVIEW / stock_30min / 2010-03-26

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-26.parquet
  size:    1.4 MB
  rows:    72,728
  symbols: 3,458

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
2010-03-26 04:00:00	AAPL	Stock	8.1679	8.1679	8.1679	8.1679	15148.0
2010-03-26 04:30:00	AAPL	Stock	8.1679	8.1679	8.1679	8.1679	11200.0
2010-03-26 05:00:00	AAPL	Stock	8.1875	8.1964	8.1829	8.1964	61852.0
2010-03-26 05:30:00	AAPL	Stock	8.1946	8.2007	8.1861	8.1861	42000.0
2010-03-26 06:00:00	AAPL	Stock	8.1861	8.2079	8.1861	8.2068	47600.0
2010-03-26 06:30:00	AAPL	Stock	8.1968	8.1968	8.185	8.185	65380.0
2010-03-26 07:00:00	AAPL	Stock	8.1704	8.1964	8.1704	8.1857	316400.0
2010-03-26 07:30:00	AAPL	Stock	8.1786	8.2139	8.1768	8.2107	968660.0
2010-03-26 08:00:00	AAPL	Stock	8.2107	8.2132	8.1857	8.1929	1921864.0
2010-03-26 08:30:00	AAPL	Stock	8.1896	8.2007	8.1746	8.1843	2649640.0
2010-03-26 09:00:00	AAPL	Stock	8.1839	8.1929	8.1707	8.1771	2391648.0
2010-03-26 09:30:00	AAPL	Stock	8.1771	8.2471	8.1625	8.2318	97465592.0
2010-03-26 10:00:00	AAPL	Stock	8.2321	8.2839	8.2304	8.2639	76723836.0
2010-03-26 10:30:00	AAPL	Stock	8.2636	8.2818	8.2379	8.2436	52940272.0
2010-03-26 11:00:00	AAPL	Stock	8.2418	8.2789	8.2418	8.2701	32900056.0
2010-03-26 11:30:00	AAPL	Stock	8.2707	8.2782	8.2432	8.2507	27619060.0
2010-03-26 12:00:00	AAPL	Stock	8.2518	8.2632	8.2157	8.2207	29884232.0
2010-03-26 12:30:00	AAPL	Stock	8.2204	8.2389	8.2	8.2032	41117468.0
2010-03-26 13:00:00	AAPL	Stock	8.2036	8.2279	8.1854	8.2146	37558976.0
2010-03-26 13:30:00	AAPL	Stock	8.2157	8.2289	8.1982	8.2036	21476560.0
2010-03-26 14:00:00	AAPL	Stock	8.2054	8.2257	8.1868	8.2243	28915936.0
2010-03-26 14:30:00	AAPL	Stock	8.2229	8.2354	8.2121	8.2218	24069024.0
2010-03-26 15:00:00	AAPL	Stock	8.2218	8.2375	8.2054	8.2189	26690104.0
2010-03-26 15:30:00	AAPL	Stock	8.2189	8.25	8.2175	8.2468	52685052.0
2010-03-26 16:00:00	AAPL	Stock	8.2468	8.2661	8.2262	8.2532	14628460.0
2010-03-26 16:30:00	AAPL	Stock	8.2532	8.2571	8.2167	8.2546	695548.0
2010-03-26 17:00:00	AAPL	Stock	8.2546	8.2557	8.2507	8.2536	250124.0
2010-03-26 17:30:00	AAPL	Stock	8.2539	8.2568	8.25	8.2554	221564.0
2010-03-26 18:00:00	AAPL	Stock	8.2464	8.2568	8.2464	8.2568	315504.0
2010-03-26 18:30:00	AAPL	Stock	8.2554	8.2571	8.255	8.255	31164.0
2010-03-26 19:00:00	AAPL	Stock	8.255	8.255	8.2536	8.2546	33600.0
2010-03-26 19:30:00	AAPL	Stock	8.2546	8.2561	8.2511	8.2536	70476.0
2010-03-26 20:00:00	AAPL	Stock	8.0896	8.0896	8.0896	8.0896	244552.0
2010-03-26 06:30:00	MSFT	Stock	30.15	30.15	30.15	30.15	100.0
2010-03-26 07:00:00	MSFT	Stock	30.15	30.22	30.15	30.2	1200.0
2010-03-26 07:30:00	MSFT	Stock	30.11	30.11	30.11	30.11	300.0
2010-03-26 08:00:00	MSFT	Stock	30.1	30.2	30.1	30.16	23932.0
2010-03-26 08:30:00	MSFT	Stock	30.18	30.3	30.15	30.2	27875.0
2010-03-26 09:00:00	MSFT	Stock	30.21	30.21	30.04	30.09	43911.0
2010-03-26 09:30:00	MSFT	Stock	30.09	30.2	29.89	29.952	8578395.0
2010-03-26 10:00:00	MSFT	Stock	29.95	29.97	29.82	29.85	6274869.0
2010-03-26 10:30:00	MSFT	Stock	29.85	29.89	29.81	29.85	3044189.0
2010-03-26 11:00:00	MSFT	Stock	29.84	29.87	29.81	29.84	2468210.0
2010-03-26 11:30:00	MSFT	Stock	29.84	29.85	29.74	29.76	2585422.0
2010-03-26 12:00:00	MSFT	Stock	29.755	29.83	29.65	29.68	3422037.0
2010-03-26 12:30:00	MSFT	Stock	29.68	29.701	29.61	29.64	3775286.0
2010-03-26 13:00:00	MSFT	Stock	29.64	29.76	29.61	29.73	2750822.0
2010-03-26 13:30:00	MSFT	Stock	29.72	29.73	29.64	29.641	1684038.0
2010-03-26 14:00:00	MSFT	Stock	29.642	29.78	29.61	29.762	3668279.0
2010-03-26 14:30:00	MSFT	Stock	29.762	29.8	29.66	29.7	2669253.0

> showing 50 of 72,728 rows — these rows as CSV

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