PREVIEW / etf_1hour / 2019-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-25.parquet
  size:    324 KB
  rows:    10,781

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-04-25 04:00:00	SPY	ETF	292.23	292.5	292.12	292.5	10568.0
2019-04-25 05:00:00	SPY	ETF	292.56	292.56	292.3	292.3	6354.0
2019-04-25 06:00:00	SPY	ETF	292.37	292.48	292.05	292.23	23644.0
2019-04-25 07:00:00	SPY	ETF	292.28	292.55	292.28	292.55	176628.0
2019-04-25 08:00:00	SPY	ETF	292.38	292.8	292.38	292.48	447991.0
2019-04-25 09:00:00	SPY	ETF	292.48	292.5	291.23	291.84	7173644.0
2019-04-25 10:00:00	SPY	ETF	291.85	292.07	290.73	291.69	10946390.0
2019-04-25 11:00:00	SPY	ETF	291.68	292.78	291.535	292.61	9365900.0
2019-04-25 12:00:00	SPY	ETF	292.61	292.73	292.23	292.42	4287318.0
2019-04-25 13:00:00	SPY	ETF	292.42	292.585	292.28	292.545	2384652.0
2019-04-25 14:00:00	SPY	ETF	292.55	292.78	292.54	292.69	3191551.0
2019-04-25 15:00:00	SPY	ETF	292.69	292.76	292.07	292.08	9979231.0
2019-04-25 16:00:00	SPY	ETF	292.07	292.3727	291.63	291.65	4425655.0
2019-04-25 17:00:00	SPY	ETF	291.7	292.05	291.29	291.7	4078529.0
2019-04-25 18:00:00	SPY	ETF	291.68	292.05	291.52	291.74	97455.0
2019-04-25 19:00:00	SPY	ETF	291.76	291.8	291.59	291.62	31843.0
2019-04-25 04:00:00	QQQ	ETF	190.98	191.14	190.86	191.11	30422.0
2019-04-25 05:00:00	QQQ	ETF	191.14	191.17	190.97	191.01	12300.0
2019-04-25 06:00:00	QQQ	ETF	191.01	191.18	190.97	191.11	28961.0
2019-04-25 07:00:00	QQQ	ETF	191.15	191.39	191.15	191.37	92548.0
2019-04-25 08:00:00	QQQ	ETF	191.24	191.58	190.99	191.46	333237.0
2019-04-25 09:00:00	QQQ	ETF	191.44	191.47	190.3931	190.91	4888220.0
2019-04-25 10:00:00	QQQ	ETF	190.92	191.11	189.45	190.48	5314729.0
2019-04-25 11:00:00	QQQ	ETF	190.48	190.99	190.08	190.83	3631751.0
2019-04-25 12:00:00	QQQ	ETF	190.85	190.945	190.51	190.6276	1587950.0
2019-04-25 13:00:00	QQQ	ETF	190.63	190.75	190.45	190.705	1243080.0
2019-04-25 14:00:00	QQQ	ETF	190.72	190.98	190.715	190.91	1081531.0
2019-04-25 15:00:00	QQQ	ETF	190.9	190.92	190.4	190.41	3165703.0
2019-04-25 16:00:00	QQQ	ETF	190.4	190.73	189.48	189.49	2202503.0
2019-04-25 17:00:00	QQQ	ETF	189.64	189.71	189.05	189.61	94209.0
2019-04-25 18:00:00	QQQ	ETF	189.54	190.48	189.45	189.72	83523.0
2019-04-25 19:00:00	QQQ	ETF	189.73	189.77	189.58	189.58	33578.0
2019-04-25 04:00:00	IWM	ETF	157.69	157.69	157.69	157.69	360.0
2019-04-25 05:00:00	IWM	ETF	157.77	157.77	157.77	157.77	1260.0
2019-04-25 07:00:00	IWM	ETF	157.61	157.72	157.59	157.67	19566.0
2019-04-25 08:00:00	IWM	ETF	157.6	157.73	157.42	157.48	80328.0
2019-04-25 09:00:00	IWM	ETF	157.51	157.54	156.29	157.07	3477145.0
2019-04-25 10:00:00	IWM	ETF	157.04	157.17	155.47	156.34	4009173.0
2019-04-25 11:00:00	IWM	ETF	156.334	156.935	155.79	156.76	2423428.0
2019-04-25 12:00:00	IWM	ETF	156.77	157.19	156.61	157.1649	1388093.0
2019-04-25 13:00:00	IWM	ETF	157.1621	157.2	156.76	156.96	926774.0
2019-04-25 14:00:00	IWM	ETF	156.96	157.23	156.92	157.02	827003.0
2019-04-25 15:00:00	IWM	ETF	157.01	157.025	156.61	156.75	2429216.0
2019-04-25 16:00:00	IWM	ETF	156.75	156.87	156.56	156.56	783917.0
2019-04-25 17:00:00	IWM	ETF	156.75	156.75	156.75	156.75	842212.0
2019-04-25 18:00:00	IWM	ETF	156.6	156.66	156.51	156.66	3310.0
2019-04-25 04:00:00	DIA	ETF	265.07	265.18	265.07	265.18	2800.0
2019-04-25 06:00:00	DIA	ETF	265.22	265.22	264.2	264.28	13763.0
2019-04-25 07:00:00	DIA	ETF	264.4	264.61	264.33	264.61	5738.0
2019-04-25 08:00:00	DIA	ETF	264.2501	265.8	264.2501	264.46	14099.0

> showing 50 of 10,781 rows — these rows as CSV

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