PREVIEW / etf_1hour / 2019-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-03.parquet
  size:    221 KB
  rows:    6,939

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-07-03 04:00:00	SPY	ETF	297.16	297.56	297.13	297.5	20981.0
2019-07-03 05:00:00	SPY	ETF	297.55	297.66	297.51	297.6	7880.0
2019-07-03 06:00:00	SPY	ETF	297.55	297.69	297.5	297.68	44540.0
2019-07-03 07:00:00	SPY	ETF	297.63	297.7	297.39	297.39	97442.0
2019-07-03 08:00:00	SPY	ETF	297.63	297.68	296.41	297.43	309987.0
2019-07-03 09:00:00	SPY	ETF	297.42	297.49	297.02	297.345	4273580.0
2019-07-03 10:00:00	SPY	ETF	297.32	298.01	297.2	297.91	6509384.0
2019-07-03 11:00:00	SPY	ETF	297.905	298.35	297.65	298.34	6362392.0
2019-07-03 12:00:00	SPY	ETF	298.33	298.82	298.2602	298.76	12962289.0
2019-07-03 13:00:00	SPY	ETF	298.75	298.95	298.48	298.56	5583017.0
2019-07-03 14:00:00	SPY	ETF	298.56	298.88	298.53	298.6	595972.0
2019-07-03 15:00:00	SPY	ETF	298.62	298.74	298.62	298.72	11622.0
2019-07-03 16:00:00	SPY	ETF	298.7	298.79	298.56	298.77	26053.0
2019-07-03 04:00:00	QQQ	ETF	190.75	191.03	190.74	190.99	18869.0
2019-07-03 05:00:00	QQQ	ETF	191.03	191.16	190.96	191.03	11408.0
2019-07-03 06:00:00	QQQ	ETF	190.99	191.16	190.97	191.08	15438.0
2019-07-03 07:00:00	QQQ	ETF	191.07	191.08	190.76	190.76	36797.0
2019-07-03 08:00:00	QQQ	ETF	190.74	191.06	190.12	190.72	131912.0
2019-07-03 09:00:00	QQQ	ETF	190.73	190.77	190.29	190.58	2480173.0
2019-07-03 10:00:00	QQQ	ETF	190.58	191.13	190.48	191.05	3204741.0
2019-07-03 11:00:00	QQQ	ETF	191.05	191.19	190.79	191.12	2593597.0
2019-07-03 12:00:00	QQQ	ETF	191.115	191.44	191.01	191.44	3930906.0
2019-07-03 13:00:00	QQQ	ETF	191.43	191.68	191.4	191.4	774747.0
2019-07-03 14:00:00	QQQ	ETF	191.39	191.64	191.35	191.5139	368595.0
2019-07-03 15:00:00	QQQ	ETF	191.53	191.54	191.5	191.54	10806.0
2019-07-03 16:00:00	QQQ	ETF	191.5	191.6	191.4	191.5	5610.0
2019-07-03 04:00:00	IWM	ETF	155.64	155.76	155.64	155.76	800.0
2019-07-03 05:00:00	IWM	ETF	155.79	155.79	155.79	155.79	100.0
2019-07-03 06:00:00	IWM	ETF	155.81	155.91	155.81	155.9	4000.0
2019-07-03 07:00:00	IWM	ETF	155.85	155.9	155.85	155.86	1000.0
2019-07-03 08:00:00	IWM	ETF	155.84	155.94	155.76	155.84	10355.0
2019-07-03 09:00:00	IWM	ETF	155.82	155.85	155.17	155.69	1485975.0
2019-07-03 10:00:00	IWM	ETF	155.67	156.32	155.4	155.99	2412036.0
2019-07-03 11:00:00	IWM	ETF	156.02	156.3	155.69	156.2436	1368262.0
2019-07-03 12:00:00	IWM	ETF	156.24	156.34	156.02	156.26	2589737.0
2019-07-03 13:00:00	IWM	ETF	156.27	156.61	156.17	156.36	714659.0
2019-07-03 14:00:00	IWM	ETF	156.31	156.42	156.26	156.39	5140.0
2019-07-03 15:00:00	IWM	ETF	156.3	156.39	156.29	156.32	8614.0
2019-07-03 16:00:00	IWM	ETF	156.29	156.37	156.27	156.37	1851.0
2019-07-03 04:00:00	DIA	ETF	268.12	268.12	268.12	268.12	400.0
2019-07-03 06:00:00	DIA	ETF	268.46	268.54	268.46	268.46	2264.0
2019-07-03 07:00:00	DIA	ETF	268.54	268.54	268.54	268.54	800.0
2019-07-03 08:00:00	DIA	ETF	268.44	268.47	268.36	268.47	2880.0
2019-07-03 09:00:00	DIA	ETF	268.51	268.61	268.28	268.43	285497.0
2019-07-03 10:00:00	DIA	ETF	268.43	268.93	268.29	268.76	216631.0
2019-07-03 11:00:00	DIA	ETF	268.7598	269.13	268.48	269.12	276967.0
2019-07-03 12:00:00	DIA	ETF	269.12	269.6	269.075	269.54	333314.0
2019-07-03 13:00:00	DIA	ETF	269.54	269.79	269.54	269.56	44777.0
2019-07-03 14:00:00	DIA	ETF	269.4415	269.4415	269.3908	269.3908	2201.0
2019-07-03 04:00:00	GLD	ETF	134.0	134.44	134.0	134.44	5200.0

> showing 50 of 6,939 rows — these rows as CSV

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