PREVIEW / stock_30min / 2015-08-05

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-05.parquet
  size:    1.6 MB
  rows:    82,176
  symbols: 3,482

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
2015-08-05 04:00:00	AAPL	Stock	28.625	28.625	28.5	28.5	80748.0
2015-08-05 04:30:00	AAPL	Stock	28.4675	28.5	28.4675	28.5	8492.0
2015-08-05 05:00:00	AAPL	Stock	28.4975	28.5125	28.485	28.4875	12640.0
2015-08-05 05:30:00	AAPL	Stock	28.47	28.535	28.47	28.535	19268.0
2015-08-05 06:00:00	AAPL	Stock	28.5075	28.5075	28.2	28.2375	648092.0
2015-08-05 06:30:00	AAPL	Stock	28.2375	28.3125	28.2125	28.275	234024.0
2015-08-05 07:00:00	AAPL	Stock	28.3	28.4225	28.3	28.3625	212948.0
2015-08-05 07:30:00	AAPL	Stock	28.3725	29.3775	28.3725	28.4625	475892.0
2015-08-05 08:00:00	AAPL	Stock	28.465	28.545	28.3	28.4625	1617852.0
2015-08-05 08:30:00	AAPL	Stock	28.4625	28.475	28.375	28.395	1225448.0
2015-08-05 09:00:00	AAPL	Stock	28.405	28.405	28.2375	28.2375	2349308.0
2015-08-05 09:30:00	AAPL	Stock	28.2425	28.985	28.025	28.98	94461232.0
2015-08-05 10:00:00	AAPL	Stock	28.97	29.155	28.6325	29.13	46757920.0
2015-08-05 10:30:00	AAPL	Stock	29.1325	29.2825	29.02	29.28	34469972.0
2015-08-05 11:00:00	AAPL	Stock	29.28	29.3575	29.1625	29.3412	24633704.0
2015-08-05 11:30:00	AAPL	Stock	29.3425	29.36	29.0625	29.1662	23035192.0
2015-08-05 12:00:00	AAPL	Stock	29.165	29.19	29.0475	29.1325	15739548.0
2015-08-05 12:30:00	AAPL	Stock	29.1325	29.165	29.035	29.16	15031400.0
2015-08-05 13:00:00	AAPL	Stock	29.1575	29.16	28.895	28.92	18237016.0
2015-08-05 13:30:00	AAPL	Stock	28.92	28.925	28.655	28.7425	24141540.0
2015-08-05 14:00:00	AAPL	Stock	28.7438	28.8125	28.68	28.755	14219032.0
2015-08-05 14:30:00	AAPL	Stock	28.755	28.9475	28.7525	28.9325	15365744.0
2015-08-05 15:00:00	AAPL	Stock	28.935	28.96	28.855	28.9375	13132776.0
2015-08-05 15:30:00	AAPL	Stock	28.9385	28.9388	28.83	28.8475	19711716.0
2015-08-05 16:00:00	AAPL	Stock	28.85	29.138	28.5125	28.8375	7083660.0
2015-08-05 16:30:00	AAPL	Stock	28.8425	28.8425	28.8	28.825	96188.0
2015-08-05 17:00:00	AAPL	Stock	28.8425	28.8425	28.7775	28.79	52824.0
2015-08-05 17:30:00	AAPL	Stock	28.79	28.825	28.78	28.8125	52620.0
2015-08-05 18:00:00	AAPL	Stock	28.8025	28.85	28.8025	28.85	53456.0
2015-08-05 18:30:00	AAPL	Stock	28.8375	28.875	28.8375	28.8575	38212.0
2015-08-05 19:00:00	AAPL	Stock	28.85	28.8725	28.85	28.8725	19240.0
2015-08-05 19:30:00	AAPL	Stock	28.8725	28.925	28.8725	28.925	95140.0
2015-08-05 04:30:00	MSFT	Stock	47.54	47.54	47.54	47.54	532.0
2015-08-05 06:30:00	MSFT	Stock	47.69	47.69	47.69	47.69	100.0
2015-08-05 07:00:00	MSFT	Stock	47.74	48.05	47.74	48.05	3018.0
2015-08-05 07:30:00	MSFT	Stock	47.9	47.9	47.9	47.9	1745.0
2015-08-05 08:00:00	MSFT	Stock	47.9	47.97	47.88	47.88	25108.0
2015-08-05 08:30:00	MSFT	Stock	47.9	47.95	47.87	47.88	19899.0
2015-08-05 09:00:00	MSFT	Stock	47.84	47.99	47.82	47.99	5612.0
2015-08-05 09:30:00	MSFT	Stock	47.87	48.41	47.87	48.02	4181047.0
2015-08-05 10:00:00	MSFT	Stock	48.01	48.2	47.924	47.96	2352617.0
2015-08-05 10:30:00	MSFT	Stock	47.97	48.0	47.65	47.68	2247670.0
2015-08-05 11:00:00	MSFT	Stock	47.67	47.97	47.64	47.94	1421093.0
2015-08-05 11:30:00	MSFT	Stock	47.94	48.0	47.89	47.92	1044280.0
2015-08-05 12:00:00	MSFT	Stock	47.921	48.08	47.85	47.965	1188457.0
2015-08-05 12:30:00	MSFT	Stock	47.965	47.97	47.76	47.91	1051192.0
2015-08-05 13:00:00	MSFT	Stock	47.92	47.95	47.7	47.8	959447.0
2015-08-05 13:30:00	MSFT	Stock	47.8	47.88	47.74	47.86	912998.0
2015-08-05 14:00:00	MSFT	Stock	47.85	47.93	47.8	47.9	981228.0
2015-08-05 14:30:00	MSFT	Stock	47.9	47.92	47.73	47.75	997559.0

> showing 50 of 82,176 rows — these rows as CSV

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