PREVIEW / etf_30min / 2018-04-03

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-03.parquet
  size:    467 KB
  rows:    16,038

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-04-03 04:00:00	SPY	ETF	257.91	258.06	257.87	258.06	28523.0
2018-04-03 04:30:00	SPY	ETF	258.02	258.09	258.0	258.05	6404.0
2018-04-03 05:00:00	SPY	ETF	258.01	258.15	257.86	257.86	3460.0
2018-04-03 05:30:00	SPY	ETF	257.94	257.94	257.85	257.85	6677.0
2018-04-03 06:00:00	SPY	ETF	257.92	258.19	257.92	258.13	13660.0
2018-04-03 06:30:00	SPY	ETF	258.26	258.47	258.19	258.19	63502.0
2018-04-03 07:00:00	SPY	ETF	258.15	258.47	258.04	258.1	106017.0
2018-04-03 07:30:00	SPY	ETF	258.1	258.45	258.02	258.42	48576.0
2018-04-03 08:00:00	SPY	ETF	258.47	258.92	257.7	258.84	261638.0
2018-04-03 08:30:00	SPY	ETF	258.84	259.1	258.66	259.03	409112.0
2018-04-03 09:00:00	SPY	ETF	259.03	259.08	258.74	258.93	590025.0
2018-04-03 09:30:00	SPY	ETF	258.87	259.23	258.04	258.37	16592353.0
2018-04-03 10:00:00	SPY	ETF	258.37	258.42	256.84	257.84	7379162.0
2018-04-03 10:30:00	SPY	ETF	257.82	259.35	257.63	259.17	7555668.0
2018-04-03 11:00:00	SPY	ETF	259.15	260.08	259.11	259.21	7048187.0
2018-04-03 11:30:00	SPY	ETF	259.21	259.4	258.09	258.11	5613540.0
2018-04-03 12:00:00	SPY	ETF	258.11	258.85	257.85	258.0192	5992832.0
2018-04-03 12:30:00	SPY	ETF	258.01	258.8	257.96	258.33	3306259.0
2018-04-03 13:00:00	SPY	ETF	258.32	259.4	258.01	259.08	4582775.0
2018-04-03 13:30:00	SPY	ETF	259.08	259.25	258.37	259.07	6187578.0
2018-04-03 14:00:00	SPY	ETF	259.07	259.2299	257.9771	258.18	5597548.0
2018-04-03 14:30:00	SPY	ETF	258.17	259.71	257.4	259.4	10510252.0
2018-04-03 15:00:00	SPY	ETF	259.4	261.31	259.17	261.09	15090999.0
2018-04-03 15:30:00	SPY	ETF	261.09	261.13	259.72	260.77	15441294.0
2018-04-03 16:00:00	SPY	ETF	260.8	260.86	259.09	260.74	4784469.0
2018-04-03 16:30:00	SPY	ETF	260.72	260.82	258.4627	260.61	930728.0
2018-04-03 17:00:00	SPY	ETF	260.6	260.65	260.55	260.58	121859.0
2018-04-03 17:30:00	SPY	ETF	260.54	260.63	260.48	260.58	103007.0
2018-04-03 18:00:00	SPY	ETF	260.48	260.6	260.37	260.52	126496.0
2018-04-03 18:30:00	SPY	ETF	260.52	260.55	260.36	260.54	66617.0
2018-04-03 19:00:00	SPY	ETF	260.5	260.5	260.34	260.4	18773.0
2018-04-03 19:30:00	SPY	ETF	260.42	260.47	260.19	260.28	16099.0
2018-04-03 04:00:00	QQQ	ETF	156.1	156.25	156.0	156.07	46516.0
2018-04-03 04:30:00	QQQ	ETF	156.16	156.27	156.1	156.19	7350.0
2018-04-03 05:00:00	QQQ	ETF	156.14	156.33	156.01	156.06	3200.0
2018-04-03 05:30:00	QQQ	ETF	156.1	156.16	156.02	156.02	3711.0
2018-04-03 06:00:00	QQQ	ETF	156.1	156.19	156.0	156.19	3600.0
2018-04-03 06:30:00	QQQ	ETF	156.3	156.57	156.29	156.3	24100.0
2018-04-03 07:00:00	QQQ	ETF	156.29	156.39	156.14	156.21	95564.0
2018-04-03 07:30:00	QQQ	ETF	156.16	156.45	156.11	156.45	77910.0
2018-04-03 08:00:00	QQQ	ETF	156.45	157.05	156.13	156.99	173809.0
2018-04-03 08:30:00	QQQ	ETF	157.04	157.18	156.83	157.17	219082.0
2018-04-03 09:00:00	QQQ	ETF	157.17	157.17	156.89	156.96	308599.0
2018-04-03 09:30:00	QQQ	ETF	156.92	157.255	155.78	155.97	5621071.0
2018-04-03 10:00:00	QQQ	ETF	155.98	156.0	154.44	155.365	5629965.0
2018-04-03 10:30:00	QQQ	ETF	155.36	156.71	155.26	156.53	5943815.0
2018-04-03 11:00:00	QQQ	ETF	156.53	157.6	156.52	156.82	4466734.0
2018-04-03 11:30:00	QQQ	ETF	156.8	156.94	155.41	155.42	3073609.0
2018-04-03 12:00:00	QQQ	ETF	155.44	156.0799	155.055	155.301	2194736.0
2018-04-03 12:30:00	QQQ	ETF	155.27	155.98	155.19	155.61	1648727.0

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

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