PREVIEW / etf_1hour / 2020-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-06.parquet
  size:    384 KB
  rows:    13,186

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
2020-04-06 04:00:00	SPY	ETF	258.24	258.7	257.01	258.2	245362.0
2020-04-06 05:00:00	SPY	ETF	258.18	258.69	257.53	258.35	269896.0
2020-04-06 06:00:00	SPY	ETF	258.34	258.49	257.3	257.84	523592.0
2020-04-06 07:00:00	SPY	ETF	257.97	258.11	257.35	257.71	760699.0
2020-04-06 08:00:00	SPY	ETF	257.69	259.0	256.59	257.9	1618040.0
2020-04-06 09:00:00	SPY	ETF	257.89	259.99	256.725	259.7979	17120887.0
2020-04-06 10:00:00	SPY	ETF	259.79	260.81	258.72	259.33	23636110.0
2020-04-06 11:00:00	SPY	ETF	259.33	261.24	258.91	260.85	16428126.0
2020-04-06 12:00:00	SPY	ETF	260.88	262.5	260.67	262.38	18893175.0
2020-04-06 13:00:00	SPY	ETF	262.385	262.955	261.58	262.81	14714139.0
2020-04-06 14:00:00	SPY	ETF	262.8	262.83	261.28	262.43	14602409.0
2020-04-06 15:00:00	SPY	ETF	262.43	267.0	261.74	264.96	53811512.0
2020-04-06 16:00:00	SPY	ETF	264.96	265.6109	262.6165	264.96	21091907.0
2020-04-06 17:00:00	SPY	ETF	264.99	265.22	264.8	264.85	414924.0
2020-04-06 18:00:00	SPY	ETF	264.85	265.08	263.73	264.11	563234.0
2020-04-06 19:00:00	SPY	ETF	264.1	266.61	264.0	266.55	791893.0
2020-04-06 04:00:00	QQQ	ETF	191.01	191.35	190.32	191.3	174447.0
2020-04-06 05:00:00	QQQ	ETF	191.34	191.55	190.74	191.3	85012.0
2020-04-06 06:00:00	QQQ	ETF	191.25	191.5	190.72	191.0	65683.0
2020-04-06 07:00:00	QQQ	ETF	191.06	191.06	190.28	190.55	484312.0
2020-04-06 08:00:00	QQQ	ETF	190.55	191.71	189.92	190.7	543744.0
2020-04-06 09:00:00	QQQ	ETF	190.7	191.76	189.19	191.665	7834202.0
2020-04-06 10:00:00	QQQ	ETF	191.66	192.3	191.133	191.65	7142457.0
2020-04-06 11:00:00	QQQ	ETF	191.67	192.74	191.405	192.515	5930716.0
2020-04-06 12:00:00	QQQ	ETF	192.52	193.65	192.34	193.65	4638140.0
2020-04-06 13:00:00	QQQ	ETF	193.65	194.28	193.2	194.27	3698363.0
2020-04-06 14:00:00	QQQ	ETF	194.28	194.3	193.11	194.13	4124055.0
2020-04-06 15:00:00	QQQ	ETF	194.13	197.65	193.71	196.58	14825588.0
2020-04-06 16:00:00	QQQ	ETF	196.55	197.0038	195.72	196.18	3026962.0
2020-04-06 17:00:00	QQQ	ETF	196.22	196.3	196.0	196.0	94362.0
2020-04-06 18:00:00	QQQ	ETF	195.9	196.12	195.32	195.33	73548.0
2020-04-06 19:00:00	QQQ	ETF	195.37	197.28	195.25	197.22	142390.0
2020-04-06 04:00:00	IWM	ETF	109.13	109.33	108.73	108.97	51602.0
2020-04-06 05:00:00	IWM	ETF	109.15	109.68	109.0	109.5	12056.0
2020-04-06 06:00:00	IWM	ETF	109.48	109.6	109.12	109.38	16232.0
2020-04-06 07:00:00	IWM	ETF	109.38	109.41	109.0	109.21	211275.0
2020-04-06 08:00:00	IWM	ETF	109.1599	109.4	108.69	109.28	235900.0
2020-04-06 09:00:00	IWM	ETF	109.29	111.44	108.88	111.3	6137507.0
2020-04-06 10:00:00	IWM	ETF	111.31	112.27	110.66	110.94	6633915.0
2020-04-06 11:00:00	IWM	ETF	110.94	111.83	110.59	111.65	3767474.0
2020-04-06 12:00:00	IWM	ETF	111.67	112.225	111.36	111.625	3411202.0
2020-04-06 13:00:00	IWM	ETF	111.62	111.83	111.185	111.55	2743380.0
2020-04-06 14:00:00	IWM	ETF	111.54	111.55	110.58	111.29	4056167.0
2020-04-06 15:00:00	IWM	ETF	111.28	113.34	111.0	112.61	8999455.0
2020-04-06 16:00:00	IWM	ETF	112.61	112.93	111.7514	112.26	2680973.0
2020-04-06 17:00:00	IWM	ETF	112.2	112.38	112.1	112.11	14241.0
2020-04-06 18:00:00	IWM	ETF	112.07	112.63	111.6	111.78	27194.0
2020-04-06 19:00:00	IWM	ETF	111.76	112.73	111.76	112.65	126005.0
2020-04-06 04:00:00	DIA	ETF	218.0	228.49	218.0	218.72	19831.0
2020-04-06 05:00:00	DIA	ETF	218.18	219.38	218.18	218.97	7950.0

> showing 50 of 13,186 rows — these rows as CSV

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