PREVIEW / etf_30min / 2019-01-25

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-25.parquet
  size:    493 KB
  rows:    17,056

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
2019-01-25 04:00:00	SPY	ETF	264.53	264.78	264.43	264.53	21680.0
2019-01-25 04:30:00	SPY	ETF	264.5	264.64	264.3	264.3	5650.0
2019-01-25 05:00:00	SPY	ETF	264.31	264.57	264.24	264.53	2365.0
2019-01-25 05:30:00	SPY	ETF	264.58	264.97	264.58	264.8	10722.0
2019-01-25 06:00:00	SPY	ETF	264.83	265.09	264.83	265.0	62732.0
2019-01-25 06:30:00	SPY	ETF	264.96	265.05	264.77	264.91	18797.0
2019-01-25 07:00:00	SPY	ETF	264.79	264.86	264.59	264.73	120460.0
2019-01-25 07:30:00	SPY	ETF	264.73	264.84	264.55	264.84	60042.0
2019-01-25 08:00:00	SPY	ETF	264.81	265.1	264.08	264.98	206729.0
2019-01-25 08:30:00	SPY	ETF	264.98	265.63	264.95	265.41	233564.0
2019-01-25 09:00:00	SPY	ETF	265.42	265.67	265.31	265.62	417033.0
2019-01-25 09:30:00	SPY	ETF	265.61	265.82	265.11	265.7	7136236.0
2019-01-25 10:00:00	SPY	ETF	265.7	266.28	265.68	266.11	5084707.0
2019-01-25 10:30:00	SPY	ETF	266.13	266.63	265.73	266.38	5023692.0
2019-01-25 11:00:00	SPY	ETF	266.38	266.5	265.81	265.9465	4722540.0
2019-01-25 11:30:00	SPY	ETF	265.95	266.35	265.94	266.28	6372026.0
2019-01-25 12:00:00	SPY	ETF	266.27	266.7	266.01	266.55	6692882.0
2019-01-25 12:30:00	SPY	ETF	266.55	266.64	265.52	265.97	10351786.0
2019-01-25 13:00:00	SPY	ETF	265.97	266.26	265.75	266.19	2842310.0
2019-01-25 13:30:00	SPY	ETF	266.19	266.28	265.89	266.2	2943833.0
2019-01-25 14:00:00	SPY	ETF	266.2	266.34	265.49	265.6439	6007743.0
2019-01-25 14:30:00	SPY	ETF	265.64	266.17	265.53	265.99	4273266.0
2019-01-25 15:00:00	SPY	ETF	265.99	266.09	265.56	265.66	3800993.0
2019-01-25 15:30:00	SPY	ETF	265.66	265.94	265.26	265.82	16496236.0
2019-01-25 16:00:00	SPY	ETF	265.82	265.9	265.57	265.84	11795896.0
2019-01-25 16:30:00	SPY	ETF	265.86	266.09	265.78	266.05	510656.0
2019-01-25 17:00:00	SPY	ETF	266.06	266.06	265.78	265.96	363042.0
2019-01-25 17:30:00	SPY	ETF	265.9	265.98	265.87	265.96	20490.0
2019-01-25 18:00:00	SPY	ETF	265.95	266.04	265.95	265.98	11925.0
2019-01-25 18:30:00	SPY	ETF	266.0	266.06	266.0	266.02	2056.0
2019-01-25 19:00:00	SPY	ETF	266.03	266.07	266.03	266.07	1935.0
2019-01-25 19:30:00	SPY	ETF	266.07	266.1	266.05	266.1	25432.0
2019-01-25 04:00:00	QQQ	ETF	163.8	164.0	163.8	163.94	10941.0
2019-01-25 04:30:00	QQQ	ETF	163.87	163.95	163.65	163.68	2185.0
2019-01-25 05:00:00	QQQ	ETF	163.72	163.88	163.66	163.87	8060.0
2019-01-25 05:30:00	QQQ	ETF	163.97	164.03	163.88	163.98	15700.0
2019-01-25 06:00:00	QQQ	ETF	164.03	164.2	164.01	164.1	9809.0
2019-01-25 06:30:00	QQQ	ETF	164.05	164.15	163.93	163.99	28594.0
2019-01-25 07:00:00	QQQ	ETF	163.99	164.02	163.83	163.92	40766.0
2019-01-25 07:30:00	QQQ	ETF	163.87	164.02	163.8	164.02	54876.0
2019-01-25 08:00:00	QQQ	ETF	163.97	164.19	163.4	164.11	124631.0
2019-01-25 08:30:00	QQQ	ETF	164.09	164.63	164.09	164.48	319862.0
2019-01-25 09:00:00	QQQ	ETF	164.5	164.58	164.38	164.46	252360.0
2019-01-25 09:30:00	QQQ	ETF	164.48	164.68	163.95	164.65	3626277.0
2019-01-25 10:00:00	QQQ	ETF	164.66	165.04	164.62	164.88	2335516.0
2019-01-25 10:30:00	QQQ	ETF	164.885	165.21	164.68	165.08	2285507.0
2019-01-25 11:00:00	QQQ	ETF	165.09	165.34	164.86	164.95	1323948.0
2019-01-25 11:30:00	QQQ	ETF	164.94	165.47	164.94	165.45	1863736.0
2019-01-25 12:00:00	QQQ	ETF	165.45	165.56	165.16	165.46	1746747.0
2019-01-25 12:30:00	QQQ	ETF	165.455	165.65	164.96	165.2699	2430895.0

> showing 50 of 17,056 rows — these rows as CSV

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