PREVIEW / etf_30min / 2018-11-28

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-28.parquet
  size:    510 KB
  rows:    17,558

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
2018-11-28 04:00:00	SPY	ETF	268.84	269.07	268.65	268.65	30885.0
2018-11-28 04:30:00	SPY	ETF	268.64	268.99	268.62	268.87	19700.0
2018-11-28 05:00:00	SPY	ETF	268.77	268.94	268.75	268.78	8600.0
2018-11-28 05:30:00	SPY	ETF	268.75	269.24	268.73	269.24	16050.0
2018-11-28 06:00:00	SPY	ETF	269.24	269.32	269.01	269.01	24565.0
2018-11-28 06:30:00	SPY	ETF	269.04	269.38	269.04	269.29	32240.0
2018-11-28 07:00:00	SPY	ETF	269.43	269.67	269.33	269.52	91547.0
2018-11-28 07:30:00	SPY	ETF	269.5	269.8	269.5	269.67	141896.0
2018-11-28 08:00:00	SPY	ETF	269.61	269.78	268.7	269.72	195203.0
2018-11-28 08:30:00	SPY	ETF	269.75	269.78	269.56	269.61	157764.0
2018-11-28 09:00:00	SPY	ETF	269.61	269.72	269.45	269.59	422689.0
2018-11-28 09:30:00	SPY	ETF	269.6	269.91	269.18	269.34	7262214.0
2018-11-28 10:00:00	SPY	ETF	269.33	269.655	268.74	268.8	5090292.0
2018-11-28 10:30:00	SPY	ETF	268.79	269.15	268.53	269.01	4566236.0
2018-11-28 11:00:00	SPY	ETF	269.01	269.5	268.96	269.35	4196842.0
2018-11-28 11:30:00	SPY	ETF	269.355	269.75	269.17	269.64	6132350.0
2018-11-28 12:00:00	SPY	ETF	269.635	272.55	269.61	272.35	19813636.0
2018-11-28 12:30:00	SPY	ETF	272.35	272.83	272.0201	272.33	9971240.0
2018-11-28 13:00:00	SPY	ETF	272.34	272.72	271.85	272.66	6958896.0
2018-11-28 13:30:00	SPY	ETF	272.65	273.49	272.57	273.3	10478324.0
2018-11-28 14:00:00	SPY	ETF	273.3	273.58	272.89	273.16	6165770.0
2018-11-28 14:30:00	SPY	ETF	273.16	273.36	272.77	272.81	4937984.0
2018-11-28 15:00:00	SPY	ETF	272.82	273.55	272.5473	273.48	4593997.0
2018-11-28 15:30:00	SPY	ETF	273.48	274.55	273.25	274.49	20883069.0
2018-11-28 16:00:00	SPY	ETF	274.48	274.58	273.3252	274.3	11821196.0
2018-11-28 16:30:00	SPY	ETF	274.29	274.47	274.07	274.17	964102.0
2018-11-28 17:00:00	SPY	ETF	274.19	274.25	274.04	274.24	130066.0
2018-11-28 17:30:00	SPY	ETF	274.21	274.58	273.89	273.93	109780.0
2018-11-28 18:00:00	SPY	ETF	273.91	274.13	273.77	274.08	196535.0
2018-11-28 18:30:00	SPY	ETF	274.06	274.13	273.99	274.03	21050.0
2018-11-28 19:00:00	SPY	ETF	274.03	274.25	274.0	274.11	149428.0
2018-11-28 19:30:00	SPY	ETF	274.12	274.13	273.92	273.99	39868.0
2018-11-28 04:00:00	QQQ	ETF	163.91	163.99	163.75	163.76	24034.0
2018-11-28 04:30:00	QQQ	ETF	163.75	164.02	163.74	163.92	14800.0
2018-11-28 05:00:00	QQQ	ETF	163.89	164.0	163.83	163.92	26180.0
2018-11-28 05:30:00	QQQ	ETF	163.96	164.33	163.96	164.33	62362.0
2018-11-28 06:00:00	QQQ	ETF	164.33	164.4	164.19	164.19	64157.0
2018-11-28 06:30:00	QQQ	ETF	164.18	164.44	164.18	164.44	124265.0
2018-11-28 07:00:00	QQQ	ETF	164.43	164.58	164.39	164.47	83958.0
2018-11-28 07:30:00	QQQ	ETF	164.48	164.73	164.46	164.56	171246.0
2018-11-28 08:00:00	QQQ	ETF	164.49	164.74	163.62	164.6601	195631.0
2018-11-28 08:30:00	QQQ	ETF	164.69	164.76	164.56	164.64	252654.0
2018-11-28 09:00:00	QQQ	ETF	164.64	164.68	164.5	164.61	357924.0
2018-11-28 09:30:00	QQQ	ETF	164.62	164.89	164.12	164.44	4556217.0
2018-11-28 10:00:00	QQQ	ETF	164.44	164.77	164.06	164.16	2393097.0
2018-11-28 10:30:00	QQQ	ETF	164.15	164.22	163.71	163.92	1924302.0
2018-11-28 11:00:00	QQQ	ETF	163.91	164.39	163.83	163.9725	1592319.0
2018-11-28 11:30:00	QQQ	ETF	163.97	164.46	163.875	164.34	1837893.0
2018-11-28 12:00:00	QQQ	ETF	164.37	167.1	164.34	166.92	9242808.0
2018-11-28 12:30:00	QQQ	ETF	166.91	167.23	166.54	166.58	5050719.0

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

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