PREVIEW / stock_30min / 2017-08-30

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-30.parquet
  size:    1.6 MB
  rows:    80,823
  symbols: 2,979

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
2017-08-30 04:00:00	AAPL	Stock	40.9525	40.9525	40.875	40.8875	19488.0
2017-08-30 04:30:00	AAPL	Stock	40.875	40.9	40.875	40.9	8364.0
2017-08-30 05:00:00	AAPL	Stock	40.8725	40.875	40.855	40.855	2324.0
2017-08-30 06:00:00	AAPL	Stock	40.8275	40.8375	40.8275	40.8375	9024.0
2017-08-30 06:30:00	AAPL	Stock	40.8525	40.855	40.8525	40.855	10832.0
2017-08-30 07:00:00	AAPL	Stock	40.865	40.9125	40.7318	40.8125	103076.0
2017-08-30 07:30:00	AAPL	Stock	40.8175	40.85	40.79	40.85	49356.0
2017-08-30 08:00:00	AAPL	Stock	40.83	40.91	40.825	40.8875	311200.0
2017-08-30 08:30:00	AAPL	Stock	40.8775	40.935	40.84	40.9	584672.0
2017-08-30 09:00:00	AAPL	Stock	40.91	40.97	40.875	40.9475	468252.0
2017-08-30 09:30:00	AAPL	Stock	40.93	40.9725	40.7725	40.8488	18148352.0
2017-08-30 10:00:00	AAPL	Stock	40.8475	40.885	40.7745	40.8565	7112680.0
2017-08-30 10:30:00	AAPL	Stock	40.855	40.8675	40.6725	40.83	9000428.0
2017-08-30 11:00:00	AAPL	Stock	40.8252	40.855	40.7025	40.7785	7824320.0
2017-08-30 11:30:00	AAPL	Stock	40.7775	40.8242	40.73	40.8	3638596.0
2017-08-30 12:00:00	AAPL	Stock	40.7988	40.8075	40.69	40.6925	4963664.0
2017-08-30 12:30:00	AAPL	Stock	40.6908	40.725	40.6525	40.6975	5561340.0
2017-08-30 13:00:00	AAPL	Stock	40.6975	40.8375	40.6875	40.8125	4899984.0
2017-08-30 13:30:00	AAPL	Stock	40.81	40.91	40.7812	40.8775	5119388.0
2017-08-30 14:00:00	AAPL	Stock	40.8775	40.8775	40.8075	40.855	3786864.0
2017-08-30 14:30:00	AAPL	Stock	40.855	40.865	40.79	40.8375	3452192.0
2017-08-30 15:00:00	AAPL	Stock	40.84	40.8475	40.7775	40.825	3982512.0
2017-08-30 15:30:00	AAPL	Stock	40.825	40.8375	40.7122	40.8325	10400896.0
2017-08-30 16:00:00	AAPL	Stock	40.8375	40.8475	40.7855	40.82	7342136.0
2017-08-30 16:30:00	AAPL	Stock	40.825	40.8375	40.82	40.83	434084.0
2017-08-30 17:00:00	AAPL	Stock	40.825	40.83	40.825	40.8275	17912.0
2017-08-30 17:30:00	AAPL	Stock	40.825	40.825	40.815	40.825	41980.0
2017-08-30 18:00:00	AAPL	Stock	40.8175	40.8325	40.8125	40.825	28944.0
2017-08-30 18:30:00	AAPL	Stock	40.8375	40.845	40.8275	40.84	24504.0
2017-08-30 19:00:00	AAPL	Stock	40.84	40.845	40.8375	40.845	12008.0
2017-08-30 19:30:00	AAPL	Stock	40.845	40.845	40.84	40.845	57508.0
2017-08-30 05:30:00	MSFT	Stock	73.3	73.3	73.3	73.3	243.0
2017-08-30 06:00:00	MSFT	Stock	73.3	73.3	73.2	73.2	575.0
2017-08-30 07:00:00	MSFT	Stock	73.25	73.25	73.25	73.25	1700.0
2017-08-30 07:30:00	MSFT	Stock	73.26	73.26	73.2	73.2	300.0
2017-08-30 08:00:00	MSFT	Stock	73.22	73.22	73.2	73.2	927.0
2017-08-30 08:30:00	MSFT	Stock	73.21	73.21	73.21	73.21	1066.0
2017-08-30 09:00:00	MSFT	Stock	73.2	73.2	72.95	72.98	9966.0
2017-08-30 09:30:00	MSFT	Stock	72.97	73.24	72.829	73.21	1283740.0
2017-08-30 10:00:00	MSFT	Stock	73.21	73.33	73.02	73.275	915076.0
2017-08-30 10:30:00	MSFT	Stock	73.28	73.44	73.16	73.43	681397.0
2017-08-30 11:00:00	MSFT	Stock	73.425	73.59	73.41	73.585	964471.0
2017-08-30 11:30:00	MSFT	Stock	73.585	73.72	73.55	73.6	781384.0
2017-08-30 12:00:00	MSFT	Stock	73.61	73.65	73.53	73.62	479532.0
2017-08-30 12:30:00	MSFT	Stock	73.62	73.76	73.613	73.73	510653.0
2017-08-30 13:00:00	MSFT	Stock	73.724	73.96	73.68	73.911	710992.0
2017-08-30 13:30:00	MSFT	Stock	73.92	74.075	73.9	74.03	834276.0
2017-08-30 14:00:00	MSFT	Stock	74.03	74.095	73.931	74.09	746422.0
2017-08-30 14:30:00	MSFT	Stock	74.09	74.21	74.07	74.14	927595.0
2017-08-30 15:00:00	MSFT	Stock	74.135	74.145	73.94	73.999	800153.0

> showing 50 of 80,823 rows — these rows as CSV

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