PREVIEW / etf_1hour / 2020-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-30.parquet
  size:    385 KB
  rows:    13,215

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-10-30 04:00:00	SPY	ETF	324.41	326.1	324.41	325.28	73502.0
2020-10-30 05:00:00	SPY	ETF	325.3	327.71	325.19	327.21	116125.0
2020-10-30 06:00:00	SPY	ETF	327.15	328.16	326.76	328.09	170387.0
2020-10-30 07:00:00	SPY	ETF	328.04	329.15	327.65	327.81	541013.0
2020-10-30 08:00:00	SPY	ETF	328.45	329.02	323.28	328.07	1135926.0
2020-10-30 09:00:00	SPY	ETF	328.02	329.69	326.82	327.98	9772308.0
2020-10-30 10:00:00	SPY	ETF	327.98	328.54	323.23	323.24	16166654.0
2020-10-30 11:00:00	SPY	ETF	323.26	325.48	323.24	324.84	13543422.0
2020-10-30 12:00:00	SPY	ETF	324.82	326.72	324.503	324.95	7644580.0
2020-10-30 13:00:00	SPY	ETF	324.96	325.48	323.34	324.5	8647368.0
2020-10-30 14:00:00	SPY	ETF	324.49	325.6399	322.6	323.66	11976975.0
2020-10-30 15:00:00	SPY	ETF	323.67	326.87	322.95	326.53	29184732.0
2020-10-30 16:00:00	SPY	ETF	326.52	330.2774	325.1341	327.9	18194328.0
2020-10-30 17:00:00	SPY	ETF	327.92	327.98	326.54	327.89	356182.0
2020-10-30 18:00:00	SPY	ETF	327.93	327.95	327.32	327.55	74192.0
2020-10-30 19:00:00	SPY	ETF	327.53	327.59	327.18	327.3	97448.0
2020-10-30 04:00:00	QQQ	ETF	270.64	271.82	270.64	271.28	59247.0
2020-10-30 05:00:00	QQQ	ETF	271.34	273.1	270.98	272.5	57254.0
2020-10-30 06:00:00	QQQ	ETF	272.62	274.12	272.45	273.88	354632.0
2020-10-30 07:00:00	QQQ	ETF	273.88	274.34	273.57	273.97	547166.0
2020-10-30 08:00:00	QQQ	ETF	274.0599	274.62	269.86	274.29	558352.0
2020-10-30 09:00:00	QQQ	ETF	274.26	275.24	271.595	272.4352	6026560.0
2020-10-30 10:00:00	QQQ	ETF	272.4	273.0	268.11	268.12	9169070.0
2020-10-30 11:00:00	QQQ	ETF	268.13	270.0	267.92	268.53	6145562.0
2020-10-30 12:00:00	QQQ	ETF	268.51	270.78	268.24	268.96	5188386.0
2020-10-30 13:00:00	QQQ	ETF	268.96	269.52	267.43	268.09	4799179.0
2020-10-30 14:00:00	QQQ	ETF	268.04	269.09	267.07	267.71	5209787.0
2020-10-30 15:00:00	QQQ	ETF	267.7	269.92	267.07	269.71	12222209.0
2020-10-30 16:00:00	QQQ	ETF	269.74	270.7	269.3533	270.46	3088302.0
2020-10-30 17:00:00	QQQ	ETF	270.76	270.76	269.38	270.14	486337.0
2020-10-30 18:00:00	QQQ	ETF	270.14	270.2	269.6	269.6	25370.0
2020-10-30 19:00:00	QQQ	ETF	269.61	269.77	269.2	269.58	45487.0
2020-10-30 04:00:00	IWM	ETF	152.99	153.76	152.95	153.2	6336.0
2020-10-30 05:00:00	IWM	ETF	153.31	154.31	153.11	154.14	15376.0
2020-10-30 06:00:00	IWM	ETF	153.92	154.28	153.73	154.28	124349.0
2020-10-30 07:00:00	IWM	ETF	154.28	154.82	154.08	154.08	141451.0
2020-10-30 08:00:00	IWM	ETF	154.7301	154.7301	152.89	154.15	261204.0
2020-10-30 09:00:00	IWM	ETF	154.15	155.28	153.7	154.19	3648413.0
2020-10-30 10:00:00	IWM	ETF	154.18	154.63	151.925	151.93	3559372.0
2020-10-30 11:00:00	IWM	ETF	151.92	153.0	151.92	152.74	3107314.0
2020-10-30 12:00:00	IWM	ETF	152.72	153.61	152.595	152.88	1974502.0
2020-10-30 13:00:00	IWM	ETF	152.86	153.06	152.23	152.765	1858205.0
2020-10-30 14:00:00	IWM	ETF	152.75	153.44	151.8899	152.23	2315700.0
2020-10-30 15:00:00	IWM	ETF	152.21	153.14	151.39	153.09	7860425.0
2020-10-30 16:00:00	IWM	ETF	153.08	153.85	152.86	153.76	2116411.0
2020-10-30 17:00:00	IWM	ETF	153.56	154.0	153.05	153.3	98438.0
2020-10-30 18:00:00	IWM	ETF	153.27	153.31	153.27	153.31	1375.0
2020-10-30 19:00:00	IWM	ETF	153.3	153.3	153.09	153.09	3285.0
2020-10-30 04:00:00	DIA	ETF	262.5	263.44	262.28	262.68	4529.0
2020-10-30 05:00:00	DIA	ETF	262.74	264.73	262.58	264.49	4411.0

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

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