PREVIEW / etf_30min / 2018-03-28

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-28.parquet
  size:    468 KB
  rows:    16,357

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-03-28 04:00:00	SPY	ETF	259.61	260.53	259.32	260.38	117183.0
2018-03-28 04:30:00	SPY	ETF	260.46	260.47	259.71	259.81	33852.0
2018-03-28 05:00:00	SPY	ETF	259.82	260.1	259.49	260.02	17099.0
2018-03-28 05:30:00	SPY	ETF	260.04	260.36	259.89	260.07	10639.0
2018-03-28 06:00:00	SPY	ETF	260.22	260.71	260.07	260.61	20387.0
2018-03-28 06:30:00	SPY	ETF	260.63	261.05	260.48	260.97	102094.0
2018-03-28 07:00:00	SPY	ETF	261.03	261.71	260.97	261.63	280819.0
2018-03-28 07:30:00	SPY	ETF	261.63	261.68	261.13	261.23	160189.0
2018-03-28 08:00:00	SPY	ETF	261.35	261.81	259.12	261.72	290491.0
2018-03-28 08:30:00	SPY	ETF	261.64	261.87	260.52	260.56	330652.0
2018-03-28 09:00:00	SPY	ETF	260.56	260.89	259.96	260.74	1050790.0
2018-03-28 09:30:00	SPY	ETF	260.75	261.56	259.56	261.227	12783436.0
2018-03-28 10:00:00	SPY	ETF	261.22	261.9	259.92	260.51	8695141.0
2018-03-28 10:30:00	SPY	ETF	260.51	260.95	258.58	259.76	11598293.0
2018-03-28 11:00:00	SPY	ETF	259.77	260.79	259.38	259.58	8318904.0
2018-03-28 11:30:00	SPY	ETF	259.59	261.03	259.0	260.35	9021439.0
2018-03-28 12:00:00	SPY	ETF	260.34	262.64	260.1	261.29	8738147.0
2018-03-28 12:30:00	SPY	ETF	261.28	262.01	260.24	260.2465	7934373.0
2018-03-28 13:00:00	SPY	ETF	260.2421	261.22	259.61	261.01	8042548.0
2018-03-28 13:30:00	SPY	ETF	261.01	261.76	260.26	261.08	7025914.0
2018-03-28 14:00:00	SPY	ETF	261.07	261.46	260.05	260.3	6354455.0
2018-03-28 14:30:00	SPY	ETF	260.3	261.47	260.12	260.34	7781363.0
2018-03-28 15:00:00	SPY	ETF	260.33	260.49	259.01	260.45	11539041.0
2018-03-28 15:30:00	SPY	ETF	260.44	261.25	259.72	259.84	17284066.0
2018-03-28 16:00:00	SPY	ETF	259.84	260.27	259.705	260.02	10422156.0
2018-03-28 16:30:00	SPY	ETF	260.04	260.4	259.5848	260.17	660231.0
2018-03-28 17:00:00	SPY	ETF	260.27	260.27	259.97	260.06	165991.0
2018-03-28 17:30:00	SPY	ETF	260.03	260.29	260.03	260.28	53726.0
2018-03-28 18:00:00	SPY	ETF	260.3	260.67	260.16	260.56	51826.0
2018-03-28 18:30:00	SPY	ETF	260.62	260.8	259.83	260.57	34322.0
2018-03-28 19:00:00	SPY	ETF	260.51	260.68	260.31	260.59	19520.0
2018-03-28 19:30:00	SPY	ETF	260.68	260.84	260.35	260.53	34228.0
2018-03-28 04:00:00	QQQ	ETF	157.99	158.47	157.66	158.46	80899.0
2018-03-28 04:30:00	QQQ	ETF	158.48	158.49	157.8	157.95	33451.0
2018-03-28 05:00:00	QQQ	ETF	157.95	158.26	157.64	158.23	32045.0
2018-03-28 05:30:00	QQQ	ETF	158.29	158.56	158.14	158.38	26171.0
2018-03-28 06:00:00	QQQ	ETF	158.49	158.76	158.23	158.62	33642.0
2018-03-28 06:30:00	QQQ	ETF	158.64	159.15	158.62	159.15	68521.0
2018-03-28 07:00:00	QQQ	ETF	159.14	159.91	159.06	159.8	271178.0
2018-03-28 07:30:00	QQQ	ETF	159.84	159.88	159.37	159.59	145683.0
2018-03-28 08:00:00	QQQ	ETF	159.93	159.93	159.07	159.2	193067.0
2018-03-28 08:30:00	QQQ	ETF	159.38	159.47	158.18	158.22	820447.0
2018-03-28 09:00:00	QQQ	ETF	158.2	158.37	157.52	158.28	1644824.0
2018-03-28 09:30:00	QQQ	ETF	158.21	158.93	156.59	158.6	11925647.0
2018-03-28 10:00:00	QQQ	ETF	158.6	159.39	157.35	157.85	7243111.0
2018-03-28 10:30:00	QQQ	ETF	157.84	158.27	156.04	157.26	8049085.0
2018-03-28 11:00:00	QQQ	ETF	157.25	157.87	156.51	156.62	4797219.0
2018-03-28 11:30:00	QQQ	ETF	156.65	158.25	156.32	157.7	4617180.0
2018-03-28 12:00:00	QQQ	ETF	157.69	159.78	157.48	158.57	6944757.0
2018-03-28 12:30:00	QQQ	ETF	158.58	159.17	157.58	157.66	3639849.0

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

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