PREVIEW / stock_30min / 2012-09-07

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-07.parquet
  size:    1.4 MB
  rows:    75,704
  symbols: 3,459

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-09-07 04:00:00	AAPL	Stock	24.2489	24.2489	24.2489	24.2489	2800.0
2012-09-07 04:30:00	AAPL	Stock	24.25	24.25	24.2321	24.2411	14700.0
2012-09-07 05:00:00	AAPL	Stock	24.2371	24.2375	24.2371	24.2375	5600.0
2012-09-07 06:30:00	AAPL	Stock	24.25	24.2679	24.2475	24.2475	22316.0
2012-09-07 07:00:00	AAPL	Stock	24.2443	24.2464	24.2182	24.2279	161532.0
2012-09-07 07:30:00	AAPL	Stock	24.2357	24.2375	24.2179	24.225	200760.0
2012-09-07 08:00:00	AAPL	Stock	24.2286	24.2429	24.1829	24.2321	617708.0
2012-09-07 08:30:00	AAPL	Stock	24.2321	24.2321	24.1507	24.1525	2944508.0
2012-09-07 09:00:00	AAPL	Stock	24.1525	24.2229	24.1296	24.2177	2084124.0
2012-09-07 09:30:00	AAPL	Stock	24.2143	24.2746	24.1346	24.2414	59086748.0
2012-09-07 10:00:00	AAPL	Stock	24.2451	24.3393	24.2371	24.2861	53198012.0
2012-09-07 10:30:00	AAPL	Stock	24.2875	24.3161	24.2679	24.2771	21662844.0
2012-09-07 11:00:00	AAPL	Stock	24.2775	24.3032	24.2393	24.2911	22485316.0
2012-09-07 11:30:00	AAPL	Stock	24.2896	24.3146	24.2646	24.285	14170576.0
2012-09-07 12:00:00	AAPL	Stock	24.285	24.3089	24.2718	24.29	12696544.0
2012-09-07 12:30:00	AAPL	Stock	24.2889	24.3632	24.2869	24.3536	22626772.0
2012-09-07 13:00:00	AAPL	Stock	24.3564	24.3743	24.3225	24.3445	14766472.0
2012-09-07 13:30:00	AAPL	Stock	24.3407	24.3529	24.3011	24.307	16026192.0
2012-09-07 14:00:00	AAPL	Stock	24.3051	24.3379	24.2943	24.3362	11865952.0
2012-09-07 14:30:00	AAPL	Stock	24.3368	24.355	24.3143	24.3409	9757048.0
2012-09-07 15:00:00	AAPL	Stock	24.3418	24.3421	24.2804	24.295	20077876.0
2012-09-07 15:30:00	AAPL	Stock	24.2939	24.3107	24.2821	24.2996	29207136.0
2012-09-07 16:00:00	AAPL	Stock	24.2982	24.3129	24.2821	24.2904	7296408.0
2012-09-07 16:30:00	AAPL	Stock	24.2893	24.3133	24.2875	24.2886	637252.0
2012-09-07 17:00:00	AAPL	Stock	24.2886	24.3036	24.2843	24.2971	534492.0
2012-09-07 17:30:00	AAPL	Stock	24.2946	24.3032	24.2936	24.2982	187376.0
2012-09-07 18:00:00	AAPL	Stock	24.2954	24.3	24.2914	24.2914	129220.0
2012-09-07 18:30:00	AAPL	Stock	24.2918	24.2939	24.2893	24.2893	194236.0
2012-09-07 19:00:00	AAPL	Stock	24.2893	24.2921	24.2857	24.2875	143108.0
2012-09-07 19:30:00	AAPL	Stock	24.2889	24.2893	24.2839	24.2857	97972.0
2012-09-07 05:00:00	MSFT	Stock	31.43	31.43	31.43	31.43	100.0
2012-09-07 07:30:00	MSFT	Stock	31.39	31.4	31.39	31.4	2100.0
2012-09-07 08:00:00	MSFT	Stock	31.35	31.36	31.05	31.1	70144.0
2012-09-07 08:30:00	MSFT	Stock	31.11	31.19	31.03	31.16	45176.0
2012-09-07 09:00:00	MSFT	Stock	31.15	31.16	30.69	31.03	297472.0
2012-09-07 09:30:00	MSFT	Stock	31.03	31.07	30.73	30.835	7538882.0
2012-09-07 10:00:00	MSFT	Stock	30.83	30.97	30.83	30.855	3510513.0
2012-09-07 10:30:00	MSFT	Stock	30.86	30.96	30.81	30.95	3042580.0
2012-09-07 11:00:00	MSFT	Stock	30.942	30.96	30.87	30.89	2090271.0
2012-09-07 11:30:00	MSFT	Stock	30.9	30.92	30.83	30.852	1739318.0
2012-09-07 12:00:00	MSFT	Stock	30.86	30.89	30.77	30.775	2154674.0
2012-09-07 12:30:00	MSFT	Stock	30.77	30.83	30.76	30.8	2061051.0
2012-09-07 13:00:00	MSFT	Stock	30.795	30.83	30.77	30.81	1833717.0
2012-09-07 13:30:00	MSFT	Stock	30.81	30.82	30.73	30.742	2363539.0
2012-09-07 14:00:00	MSFT	Stock	30.74	30.83	30.74	30.81	1904796.0
2012-09-07 14:30:00	MSFT	Stock	30.819	30.91	30.81	30.87	2903169.0
2012-09-07 15:00:00	MSFT	Stock	30.88	30.88	30.83	30.87	2315329.0
2012-09-07 15:30:00	MSFT	Stock	30.875	30.96	30.84	30.94	5141127.0
2012-09-07 16:00:00	MSFT	Stock	30.95	30.96	30.842	30.95	2244221.0
2012-09-07 16:30:00	MSFT	Stock	30.95	30.95	30.94	30.95	100305.0

> showing 50 of 75,704 rows — these rows as CSV

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