PREVIEW / etf_1hour / 2020-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-30.parquet
  size:    369 KB
  rows:    12,677

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-07-30 04:00:00	SPY	ETF	323.0	323.0	321.71	321.71	70839.0
2020-07-30 05:00:00	SPY	ETF	321.66	323.0	321.61	322.63	42754.0
2020-07-30 06:00:00	SPY	ETF	322.6	322.63	321.21	321.61	99628.0
2020-07-30 07:00:00	SPY	ETF	321.67	322.95	321.56	322.86	564078.0
2020-07-30 08:00:00	SPY	ETF	322.0301	324.85	321.36	321.36	1737607.0
2020-07-30 09:00:00	SPY	ETF	321.36	322.42	320.0	320.13	8190725.0
2020-07-30 10:00:00	SPY	ETF	320.13	321.62	319.64	321.4	11087001.0
2020-07-30 11:00:00	SPY	ETF	321.42	322.99	321.1	322.73	7131476.0
2020-07-30 12:00:00	SPY	ETF	322.73	323.95	322.38	323.57	5248991.0
2020-07-30 13:00:00	SPY	ETF	323.54	324.4	323.12	323.715	5131408.0
2020-07-30 14:00:00	SPY	ETF	323.71	324.29	323.16	323.9199	5849656.0
2020-07-30 15:00:00	SPY	ETF	323.915	324.41	323.35	323.98	10810477.0
2020-07-30 16:00:00	SPY	ETF	323.99	326.96	323.64	326.84	4325910.0
2020-07-30 17:00:00	SPY	ETF	326.81	326.94	326.53	326.94	201071.0
2020-07-30 18:00:00	SPY	ETF	326.94	327.43	326.2	326.52	268123.0
2020-07-30 19:00:00	SPY	ETF	326.55	327.06	326.48	326.84	104235.0
2020-07-30 04:00:00	QQQ	ETF	257.8	257.99	256.81	256.92	52787.0
2020-07-30 05:00:00	QQQ	ETF	256.81	258.29	256.71	258.02	51843.0
2020-07-30 06:00:00	QQQ	ETF	258.05	258.15	256.29	256.7	184174.0
2020-07-30 07:00:00	QQQ	ETF	256.85	258.53	256.85	258.17	584188.0
2020-07-30 08:00:00	QQQ	ETF	257.7501	260.54	256.39	257.19	583643.0
2020-07-30 09:00:00	QQQ	ETF	257.18	259.1099	256.7	257.22	5262410.0
2020-07-30 10:00:00	QQQ	ETF	257.25	258.58	256.55	258.44	5692237.0
2020-07-30 11:00:00	QQQ	ETF	258.43	260.35	258.11	259.9785	3727901.0
2020-07-30 12:00:00	QQQ	ETF	259.98	261.22	259.7711	260.74	4630994.0
2020-07-30 13:00:00	QQQ	ETF	260.73	261.5	260.41	261.27	2797522.0
2020-07-30 14:00:00	QQQ	ETF	261.25	261.6	260.43	261.3088	3092403.0
2020-07-30 15:00:00	QQQ	ETF	261.31	261.71	260.65	261.16	4995776.0
2020-07-30 16:00:00	QQQ	ETF	261.22	265.77	260.78	265.75	3264134.0
2020-07-30 17:00:00	QQQ	ETF	265.66	265.95	265.3	265.95	302582.0
2020-07-30 18:00:00	QQQ	ETF	265.98	266.53	265.41	265.57	356138.0
2020-07-30 19:00:00	QQQ	ETF	265.6	266.19	265.47	266.04	305615.0
2020-07-30 04:00:00	IWM	ETF	147.95	148.2	147.0	147.23	84495.0
2020-07-30 05:00:00	IWM	ETF	147.18	147.9	147.15	147.6	11701.0
2020-07-30 06:00:00	IWM	ETF	147.45	147.6	146.93	147.15	29475.0
2020-07-30 07:00:00	IWM	ETF	147.14	147.88	147.12	147.81	187053.0
2020-07-30 08:00:00	IWM	ETF	147.33	147.84	146.89	146.89	224134.0
2020-07-30 09:00:00	IWM	ETF	146.88	147.65	146.4	146.525	3121230.0
2020-07-30 10:00:00	IWM	ETF	146.5	147.42	146.33	147.385	2489908.0
2020-07-30 11:00:00	IWM	ETF	147.38	148.245	147.32	147.99	2244180.0
2020-07-30 12:00:00	IWM	ETF	147.99	148.72	147.97	148.375	1265637.0
2020-07-30 13:00:00	IWM	ETF	148.37	148.82	148.24	148.69	1193133.0
2020-07-30 14:00:00	IWM	ETF	148.69	148.98	148.44	148.64	2701950.0
2020-07-30 15:00:00	IWM	ETF	148.64	149.12	148.335	148.79	4016953.0
2020-07-30 16:00:00	IWM	ETF	148.8	149.37	148.28	149.15	1594422.0
2020-07-30 17:00:00	IWM	ETF	148.74	149.32	148.74	149.32	35831.0
2020-07-30 18:00:00	IWM	ETF	149.22	149.27	148.55	148.8	134525.0
2020-07-30 19:00:00	IWM	ETF	148.88	149.12	148.83	149.03	26382.0
2020-07-30 04:00:00	DIA	ETF	263.33	263.33	263.33	263.33	100.0
2020-07-30 05:00:00	DIA	ETF	263.03	263.56	263.03	263.56	200.0

> showing 50 of 12,677 rows — these rows as CSV

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