PREVIEW / stock_30min / 2016-06-06

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-06.parquet
  size:    1.6 MB
  rows:    83,159
  symbols: 3,316

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
2016-06-06 04:00:00	AAPL	Stock	24.48	24.5425	24.48	24.5425	10700.0
2016-06-06 04:30:00	AAPL	Stock	24.48	24.5275	24.48	24.5275	1720.0
2016-06-06 07:00:00	AAPL	Stock	24.5125	24.5125	24.5	24.5	9568.0
2016-06-06 07:30:00	AAPL	Stock	24.525	24.5375	24.525	24.5375	7268.0
2016-06-06 08:00:00	AAPL	Stock	24.5125	24.5225	24.4725	24.495	83368.0
2016-06-06 08:30:00	AAPL	Stock	24.495	24.495	24.425	24.495	200672.0
2016-06-06 09:00:00	AAPL	Stock	24.475	24.5	24.45	24.4725	99832.0
2016-06-06 09:30:00	AAPL	Stock	24.4975	24.73	24.3875	24.6732	18349660.0
2016-06-06 10:00:00	AAPL	Stock	24.675	24.705	24.6525	24.655	6536732.0
2016-06-06 10:30:00	AAPL	Stock	24.655	24.73	24.6525	24.7248	5414116.0
2016-06-06 11:00:00	AAPL	Stock	24.725	24.7475	24.7	24.73	5662164.0
2016-06-06 11:30:00	AAPL	Stock	24.73	24.765	24.72	24.745	4811100.0
2016-06-06 12:00:00	AAPL	Stock	24.7475	24.7525	24.67	24.6875	5041740.0
2016-06-06 12:30:00	AAPL	Stock	24.6875	24.71	24.6275	24.6825	5208888.0
2016-06-06 13:00:00	AAPL	Stock	24.685	24.73	24.665	24.725	3678224.0
2016-06-06 13:30:00	AAPL	Stock	24.725	24.7475	24.6962	24.7425	3243908.0
2016-06-06 14:00:00	AAPL	Stock	24.745	24.785	24.7425	24.765	5206768.0
2016-06-06 14:30:00	AAPL	Stock	24.765	24.7725	24.7025	24.7075	3557780.0
2016-06-06 15:00:00	AAPL	Stock	24.7075	24.73	24.6912	24.6925	3921084.0
2016-06-06 15:30:00	AAPL	Stock	24.6925	24.7338	24.6575	24.6575	9818076.0
2016-06-06 16:00:00	AAPL	Stock	24.6575	24.6875	24.6425	24.6475	5422896.0
2016-06-06 16:30:00	AAPL	Stock	24.6475	24.6475	24.6425	24.6475	28380.0
2016-06-06 17:00:00	AAPL	Stock	24.64	24.6575	24.6325	24.6575	30844.0
2016-06-06 17:30:00	AAPL	Stock	24.6625	24.665	24.645	24.6625	33112.0
2016-06-06 18:00:00	AAPL	Stock	24.6425	24.6425	24.6425	24.6425	4000.0
2016-06-06 19:00:00	AAPL	Stock	24.6575	24.6575	24.65	24.655	4176.0
2016-06-06 19:30:00	AAPL	Stock	24.6575	24.665	24.655	24.655	6044.0
2016-06-06 06:30:00	MSFT	Stock	51.79	51.79	51.79	51.79	200.0
2016-06-06 07:00:00	MSFT	Stock	51.79	51.79	51.79	51.79	200.0
2016-06-06 07:30:00	MSFT	Stock	51.79	51.79	51.79	51.79	100.0
2016-06-06 08:00:00	MSFT	Stock	51.79	51.84	51.72	51.84	10436.0
2016-06-06 08:30:00	MSFT	Stock	51.84	51.84	51.84	51.84	2000.0
2016-06-06 09:00:00	MSFT	Stock	51.83	51.93	51.83	51.93	9000.0
2016-06-06 09:30:00	MSFT	Stock	51.95	52.27	51.89	52.144	1851255.0
2016-06-06 10:00:00	MSFT	Stock	52.15	52.19	52.04	52.13	1031763.0
2016-06-06 10:30:00	MSFT	Stock	52.13	52.19	52.11	52.15	701711.0
2016-06-06 11:00:00	MSFT	Stock	52.15	52.25	52.145	52.2	902345.0
2016-06-06 11:30:00	MSFT	Stock	52.195	52.24	52.14	52.174	798040.0
2016-06-06 12:00:00	MSFT	Stock	52.17	52.18	52.11	52.16	566219.0
2016-06-06 12:30:00	MSFT	Stock	52.16	52.21	51.98	52.07	967883.0
2016-06-06 13:00:00	MSFT	Stock	52.06	52.15	52.05	52.12	956257.0
2016-06-06 13:30:00	MSFT	Stock	52.12	52.29	52.09	52.28	904857.0
2016-06-06 14:00:00	MSFT	Stock	52.27	52.35	52.25	52.33	1204181.0
2016-06-06 14:30:00	MSFT	Stock	52.33	52.35	52.16	52.167	1103243.0
2016-06-06 15:00:00	MSFT	Stock	52.17	52.24	52.145	52.215	874390.0
2016-06-06 15:30:00	MSFT	Stock	52.215	52.29	52.12	52.14	2590928.0
2016-06-06 16:00:00	MSFT	Stock	52.14	52.19	51.792	51.792	2140249.0
2016-06-06 16:30:00	MSFT	Stock	51.889	52.21	51.889	52.21	15222.0
2016-06-06 17:00:00	MSFT	Stock	52.13	52.22	52.13	52.22	3736.0
2016-06-06 17:30:00	MSFT	Stock	52.13	52.13	52.13	52.13	105099.0

> showing 50 of 83,159 rows — these rows as CSV

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