PREVIEW / etf_30min / 2018-09-20

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-20.parquet
  size:    483 KB
  rows:    16,638

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-09-20 04:00:00	SPY	ETF	291.48	291.55	291.45	291.5	7945.0
2018-09-20 04:30:00	SPY	ETF	291.53	291.55	291.33	291.37	3702.0
2018-09-20 05:00:00	SPY	ETF	291.47	291.54	291.44	291.54	1532.0
2018-09-20 05:30:00	SPY	ETF	291.55	291.73	291.55	291.65	8100.0
2018-09-20 06:00:00	SPY	ETF	291.53	291.56	291.51	291.56	900.0
2018-09-20 06:30:00	SPY	ETF	291.56	291.73	291.56	291.67	6850.0
2018-09-20 07:00:00	SPY	ETF	291.66	291.98	291.63	291.98	74802.0
2018-09-20 07:30:00	SPY	ETF	291.98	292.13	291.95	292.13	79679.0
2018-09-20 08:00:00	SPY	ETF	292.13	292.56	291.3	292.4	238883.0
2018-09-20 08:30:00	SPY	ETF	292.32	292.63	292.31	292.55	316945.0
2018-09-20 09:00:00	SPY	ETF	292.55	292.64	292.42	292.64	374085.0
2018-09-20 09:30:00	SPY	ETF	292.64	293.01	292.51	292.71	8246736.0
2018-09-20 10:00:00	SPY	ETF	292.71	293.19	292.7	292.78	8593017.0
2018-09-20 10:30:00	SPY	ETF	292.78	293.15	292.68	292.95	5110208.0
2018-09-20 11:00:00	SPY	ETF	292.955	293.23	292.94	293.21	4823978.0
2018-09-20 11:30:00	SPY	ETF	293.205	293.47	293.17	293.47	5744712.0
2018-09-20 12:00:00	SPY	ETF	293.465	293.48	293.305	293.425	4676690.0
2018-09-20 12:30:00	SPY	ETF	293.425	293.6	293.32	293.555	2732720.0
2018-09-20 13:00:00	SPY	ETF	293.54	293.72	293.41	293.41	7774214.0
2018-09-20 13:30:00	SPY	ETF	293.4	293.51	293.355	293.47	3112675.0
2018-09-20 14:00:00	SPY	ETF	293.475	293.6	293.45	293.5638	2921264.0
2018-09-20 14:30:00	SPY	ETF	293.5636	293.73	293.38	293.67	4688457.0
2018-09-20 15:00:00	SPY	ETF	293.675	293.94	293.63	293.74	11413992.0
2018-09-20 15:30:00	SPY	ETF	293.74	293.77	293.46	293.55	15790765.0
2018-09-20 16:00:00	SPY	ETF	293.54	293.85	293.49	293.82	8753787.0
2018-09-20 16:30:00	SPY	ETF	293.82	293.92	293.78	293.91	202761.0
2018-09-20 17:00:00	SPY	ETF	293.88	293.95	293.5102	293.8	733672.0
2018-09-20 17:30:00	SPY	ETF	293.8	293.83	293.75	293.79	205277.0
2018-09-20 18:00:00	SPY	ETF	293.77	293.85	293.65	293.81	110865.0
2018-09-20 18:30:00	SPY	ETF	293.77	293.82	293.7	293.76	21165.0
2018-09-20 19:00:00	SPY	ETF	293.76	293.76	293.71	293.74	10207.0
2018-09-20 19:30:00	SPY	ETF	293.73	293.93	293.71	293.89	23762.0
2018-09-20 04:00:00	QQQ	ETF	182.76	182.81	182.76	182.8	3820.0
2018-09-20 04:30:00	QQQ	ETF	182.89	182.89	182.7	182.7	3821.0
2018-09-20 05:00:00	QQQ	ETF	182.91	182.94	182.87	182.94	1765.0
2018-09-20 05:30:00	QQQ	ETF	183.0	183.17	183.0	183.15	24613.0
2018-09-20 06:00:00	QQQ	ETF	183.14	183.17	183.01	183.03	10743.0
2018-09-20 06:30:00	QQQ	ETF	183.04	183.17	183.04	183.09	7375.0
2018-09-20 07:00:00	QQQ	ETF	183.11	183.46	183.08	183.46	35924.0
2018-09-20 07:30:00	QQQ	ETF	183.46	183.58	183.45	183.58	107673.0
2018-09-20 08:00:00	QQQ	ETF	183.57	183.96	182.79	183.82	178629.0
2018-09-20 08:30:00	QQQ	ETF	183.83	184.07	183.83	183.99	147141.0
2018-09-20 09:00:00	QQQ	ETF	184.0	184.0	183.84	183.96	172496.0
2018-09-20 09:30:00	QQQ	ETF	183.94	184.33	183.5199	184.22	5114932.0
2018-09-20 10:00:00	QQQ	ETF	184.22	184.88	184.21	184.4733	3684688.0
2018-09-20 10:30:00	QQQ	ETF	184.48	184.71	184.27	184.34	1751945.0
2018-09-20 11:00:00	QQQ	ETF	184.34	184.6133	184.2901	184.53	1763954.0
2018-09-20 11:30:00	QQQ	ETF	184.536	184.91	184.485	184.65	1877388.0
2018-09-20 12:00:00	QQQ	ETF	184.65	184.66	184.3591	184.59	952662.0
2018-09-20 12:30:00	QQQ	ETF	184.6	184.81	184.46	184.7246	1183312.0

> showing 50 of 16,638 rows — these rows as CSV

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