PREVIEW / stock_30min / 2010-09-22

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-22.parquet
  size:    1.3 MB
  rows:    72,715
  symbols: 3,475

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-09-22 05:00:00	AAPL	Stock	10.125	10.125	10.0914	10.0914	19600.0
2010-09-22 05:30:00	AAPL	Stock	10.0946	10.0946	10.0946	10.0946	2800.0
2010-09-22 06:30:00	AAPL	Stock	10.1018	10.1018	10.1018	10.1018	14000.0
2010-09-22 07:00:00	AAPL	Stock	10.1	10.1	10.0889	10.0889	57036.0
2010-09-22 07:30:00	AAPL	Stock	10.1	10.125	10.0946	10.0946	268548.0
2010-09-22 08:00:00	AAPL	Stock	10.0914	10.1107	10.0846	10.1061	1384068.0
2010-09-22 08:30:00	AAPL	Stock	10.1071	10.1071	10.0754	10.0857	1107008.0
2010-09-22 09:00:00	AAPL	Stock	10.0861	10.1111	10.0836	10.1057	1298556.0
2010-09-22 09:30:00	AAPL	Stock	10.0968	10.285	10.0861	10.2614	131900608.0
2010-09-22 10:00:00	AAPL	Stock	10.2618	10.275	10.1843	10.2046	88285624.0
2010-09-22 10:30:00	AAPL	Stock	10.2036	10.2353	10.1946	10.2314	45294592.0
2010-09-22 11:00:00	AAPL	Stock	10.2318	10.2375	10.1875	10.2015	31530044.0
2010-09-22 11:30:00	AAPL	Stock	10.2014	10.2382	10.1979	10.2357	25562264.0
2010-09-22 12:00:00	AAPL	Stock	10.2354	10.25	10.2229	10.2446	23454928.0
2010-09-22 12:30:00	AAPL	Stock	10.2435	10.2436	10.2146	10.225	16736636.0
2010-09-22 13:00:00	AAPL	Stock	10.225	10.2382	10.2089	10.22	24210060.0
2010-09-22 13:30:00	AAPL	Stock	10.2196	10.2579	10.2171	10.2436	30918832.0
2010-09-22 14:00:00	AAPL	Stock	10.2425	10.2464	10.2186	10.2354	22126944.0
2010-09-22 14:30:00	AAPL	Stock	10.2332	10.2757	10.2332	10.2693	36404424.0
2010-09-22 15:00:00	AAPL	Stock	10.2696	10.2725	10.2379	10.2508	27922608.0
2010-09-22 15:30:00	AAPL	Stock	10.2507	10.2768	10.2465	10.2764	48455484.0
2010-09-22 16:00:00	AAPL	Stock	10.2768	10.2836	10.216	10.2786	14094388.0
2010-09-22 16:30:00	AAPL	Stock	10.2786	10.2821	10.2125	10.2821	691572.0
2010-09-22 17:00:00	AAPL	Stock	10.1012	10.2875	10.1012	10.2854	553644.0
2010-09-22 17:30:00	AAPL	Stock	10.2829	10.2857	10.2821	10.2839	62216.0
2010-09-22 18:00:00	AAPL	Stock	10.2839	10.2857	10.2768	10.2857	556500.0
2010-09-22 18:30:00	AAPL	Stock	10.2857	10.2857	10.2782	10.2804	260540.0
2010-09-22 19:00:00	AAPL	Stock	10.2779	10.2804	10.2779	10.2804	34972.0
2010-09-22 19:30:00	AAPL	Stock	10.2804	10.285	10.2779	10.285	109928.0
2010-09-22 04:00:00	MSFT	Stock	25.34	25.34	25.13	25.13	2150.0
2010-09-22 04:30:00	MSFT	Stock	25.14	25.15	25.06	25.06	14600.0
2010-09-22 05:00:00	MSFT	Stock	25.07	25.07	25.05	25.05	2100.0
2010-09-22 05:30:00	MSFT	Stock	25.01	25.12	25.01	25.01	1300.0
2010-09-22 06:00:00	MSFT	Stock	25.06	25.06	25.01	25.04	7600.0
2010-09-22 06:30:00	MSFT	Stock	25.04	25.04	24.98	24.98	1400.0
2010-09-22 07:00:00	MSFT	Stock	25.09	25.09	24.85	24.85	48366.0
2010-09-22 07:30:00	MSFT	Stock	24.85	24.9	24.84	24.9	37869.0
2010-09-22 08:00:00	MSFT	Stock	24.9	24.95	24.83	24.94	95244.0
2010-09-22 08:30:00	MSFT	Stock	24.94	24.95	24.86	24.86	86821.0
2010-09-22 09:00:00	MSFT	Stock	24.88	24.9	24.82	24.9	316592.0
2010-09-22 09:30:00	MSFT	Stock	24.89	24.97	24.66	24.67	16868986.0
2010-09-22 10:00:00	MSFT	Stock	24.67	24.68	24.5	24.525	10875047.0
2010-09-22 10:30:00	MSFT	Stock	24.53	24.59	24.5	24.57	9625855.0
2010-09-22 11:00:00	MSFT	Stock	24.565	24.57	24.38	24.399	9831440.0
2010-09-22 11:30:00	MSFT	Stock	24.395	24.5	24.36	24.455	4359681.0
2010-09-22 12:00:00	MSFT	Stock	24.455	24.5	24.42	24.49	3568076.0
2010-09-22 12:30:00	MSFT	Stock	24.49	24.49	24.38	24.4	4912135.0
2010-09-22 13:00:00	MSFT	Stock	24.405	24.45	24.38	24.42	3492396.0
2010-09-22 13:30:00	MSFT	Stock	24.415	24.5	24.41	24.46	3076271.0
2010-09-22 14:00:00	MSFT	Stock	24.46	24.47	24.4	24.46	2636067.0

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

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