PREVIEW / stock_30min / 2012-02-29

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-29.parquet
  size:    1.5 MB
  rows:    78,482
  symbols: 3,532

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
2012-02-29 04:00:00	AAPL	Stock	19.2857	19.3296	19.2679	19.2893	168000.0
2012-02-29 04:30:00	AAPL	Stock	19.2775	19.2864	19.2775	19.2857	30800.0
2012-02-29 05:00:00	AAPL	Stock	19.2857	19.2857	19.2507	19.275	92680.0
2012-02-29 05:30:00	AAPL	Stock	19.2821	19.2857	19.2232	19.2232	96880.0
2012-02-29 06:00:00	AAPL	Stock	19.25	19.25	19.25	19.25	31388.0
2012-02-29 06:30:00	AAPL	Stock	19.2607	19.2607	19.2361	19.2411	65604.0
2012-02-29 07:00:00	AAPL	Stock	19.2496	19.2679	19.2018	19.2221	378112.0
2012-02-29 07:30:00	AAPL	Stock	19.2179	19.2379	19.1879	19.2129	710976.0
2012-02-29 08:00:00	AAPL	Stock	19.2271	19.265	19.2075	19.2571	2803416.0
2012-02-29 08:30:00	AAPL	Stock	19.2604	19.3036	19.2579	19.2875	3725596.0
2012-02-29 09:00:00	AAPL	Stock	19.2893	19.3718	19.2857	19.3329	4339048.0
2012-02-29 09:30:00	AAPL	Stock	19.3414	19.5575	19.3257	19.4582	198855440.0
2012-02-29 10:00:00	AAPL	Stock	19.4604	19.4604	19.2768	19.3811	107326408.0
2012-02-29 10:30:00	AAPL	Stock	19.3807	19.3939	19.1893	19.2979	85827672.0
2012-02-29 11:00:00	AAPL	Stock	19.2979	19.3757	19.2614	19.2844	51560824.0
2012-02-29 11:30:00	AAPL	Stock	19.2839	19.375	19.2429	19.3579	40600896.0
2012-02-29 12:00:00	AAPL	Stock	19.3621	19.4114	19.3354	19.3971	34970432.0
2012-02-29 12:30:00	AAPL	Stock	19.3961	19.4525	19.3936	19.4339	37838332.0
2012-02-29 13:00:00	AAPL	Stock	19.4339	19.4457	19.3684	19.385	27800948.0
2012-02-29 13:30:00	AAPL	Stock	19.385	19.4393	19.3457	19.4325	31202360.0
2012-02-29 14:00:00	AAPL	Stock	19.4321	19.4461	19.4054	19.4417	21133224.0
2012-02-29 14:30:00	AAPL	Stock	19.4432	19.4511	19.4	19.4214	26223736.0
2012-02-29 15:00:00	AAPL	Stock	19.4204	19.4821	19.3796	19.415	63146776.0
2012-02-29 15:30:00	AAPL	Stock	19.4145	19.4145	19.1321	19.3707	160941004.0
2012-02-29 16:00:00	AAPL	Stock	19.3595	19.406	19.1218	19.3696	24966088.0
2012-02-29 16:30:00	AAPL	Stock	19.3714	19.4057	19.2616	19.3782	4934580.0
2012-02-29 17:00:00	AAPL	Stock	19.3507	19.3786	19.3411	19.3429	391804.0
2012-02-29 17:30:00	AAPL	Stock	19.3432	19.3729	19.3354	19.3446	870632.0
2012-02-29 18:00:00	AAPL	Stock	19.3464	19.3636	19.3368	19.3396	416472.0
2012-02-29 18:30:00	AAPL	Stock	19.3464	19.3643	19.3432	19.3432	89936.0
2012-02-29 19:00:00	AAPL	Stock	19.3436	19.3643	19.3436	19.3643	158340.0
2012-02-29 19:30:00	AAPL	Stock	19.3625	19.3718	19.3589	19.3696	494312.0
2012-02-29 05:30:00	MSFT	Stock	31.98	31.99	31.98	31.99	2200.0
2012-02-29 07:00:00	MSFT	Stock	31.99	31.99	31.99	31.99	300.0
2012-02-29 08:00:00	MSFT	Stock	31.96	31.96	31.92	31.92	4300.0
2012-02-29 08:30:00	MSFT	Stock	31.93	31.93	31.92	31.92	9607.0
2012-02-29 09:00:00	MSFT	Stock	31.91	31.91	31.88	31.88	94420.0
2012-02-29 09:30:00	MSFT	Stock	31.88	31.94	31.8	31.92	5896303.0
2012-02-29 10:00:00	MSFT	Stock	31.92	32.0	31.9	31.936	5547018.0
2012-02-29 10:30:00	MSFT	Stock	31.93	31.95	31.76	31.88	5447267.0
2012-02-29 11:00:00	MSFT	Stock	31.88	31.89	31.72	31.75	4299131.0
2012-02-29 11:30:00	MSFT	Stock	31.75	31.86	31.72	31.805	3546718.0
2012-02-29 12:00:00	MSFT	Stock	31.8	31.86	31.76	31.85	2283125.0
2012-02-29 12:30:00	MSFT	Stock	31.846	31.85	31.72	31.76	2125262.0
2012-02-29 13:00:00	MSFT	Stock	31.77	31.8	31.73	31.74	2377615.0
2012-02-29 13:30:00	MSFT	Stock	31.745	31.8	31.67	31.77	3020940.0
2012-02-29 14:00:00	MSFT	Stock	31.77	31.84	31.74	31.75	1498863.0
2012-02-29 14:30:00	MSFT	Stock	31.76	31.76	31.67	31.72	3754582.0
2012-02-29 15:00:00	MSFT	Stock	31.72	31.73	31.63	31.67	4016909.0
2012-02-29 15:30:00	MSFT	Stock	31.67	31.76	31.61	31.74	7366956.0

> showing 50 of 78,482 rows — these rows as CSV

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