PREVIEW / etf_1hour / 2019-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-29.parquet
  size:    318 KB
  rows:    10,705

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-29 04:00:00	SPY	ETF	301.62	301.81	301.62	301.68	4446.0
2019-07-29 05:00:00	SPY	ETF	301.68	301.76	301.6	301.61	9458.0
2019-07-29 06:00:00	SPY	ETF	301.66	301.8	301.53	301.53	11342.0
2019-07-29 07:00:00	SPY	ETF	301.5	302.05	301.5	301.97	84332.0
2019-07-29 08:00:00	SPY	ETF	302.0	302.02	301.36	301.86	691394.0
2019-07-29 09:00:00	SPY	ETF	301.88	301.94	301.07	301.13	5380503.0
2019-07-29 10:00:00	SPY	ETF	301.125	301.44	300.85	301.28	7298021.0
2019-07-29 11:00:00	SPY	ETF	301.28	301.69	301.17	301.6	4138114.0
2019-07-29 12:00:00	SPY	ETF	301.61	301.63	301.22	301.6268	2212944.0
2019-07-29 13:00:00	SPY	ETF	301.6273	301.73	301.45	301.46	2771066.0
2019-07-29 14:00:00	SPY	ETF	301.46	301.62	301.33	301.54	2599750.0
2019-07-29 15:00:00	SPY	ETF	301.53	301.74	301.34	301.48	8604835.0
2019-07-29 16:00:00	SPY	ETF	301.48	301.7	301.44	301.61	3368705.0
2019-07-29 17:00:00	SPY	ETF	301.61	301.63	301.46	301.57	60932.0
2019-07-29 18:00:00	SPY	ETF	301.58	301.84	301.46	301.77	66737.0
2019-07-29 19:00:00	SPY	ETF	301.8	301.83	301.76	301.81	15860.0
2019-07-29 04:00:00	QQQ	ETF	195.05	195.11	194.97	194.98	11999.0
2019-07-29 05:00:00	QQQ	ETF	194.97	195.03	194.89	194.93	6464.0
2019-07-29 06:00:00	QQQ	ETF	194.96	195.06	194.87	194.93	10984.0
2019-07-29 07:00:00	QQQ	ETF	194.92	195.34	194.92	195.26	37292.0
2019-07-29 08:00:00	QQQ	ETF	194.95	195.33	194.95	195.25	45785.0
2019-07-29 09:00:00	QQQ	ETF	195.25	195.33	193.76	193.845	3416859.0
2019-07-29 10:00:00	QQQ	ETF	193.84	194.13	193.39	193.9	4947973.0
2019-07-29 11:00:00	QQQ	ETF	193.91	194.39	193.81	194.29	2022367.0
2019-07-29 12:00:00	QQQ	ETF	194.29	194.44	193.98	194.43	1426984.0
2019-07-29 13:00:00	QQQ	ETF	194.43	194.59	194.34	194.4	1290364.0
2019-07-29 14:00:00	QQQ	ETF	194.41	194.72	194.31	194.67	896689.0
2019-07-29 15:00:00	QQQ	ETF	194.66	194.81	194.53	194.64	2399313.0
2019-07-29 16:00:00	QQQ	ETF	194.64	194.74	194.57	194.73	617866.0
2019-07-29 17:00:00	QQQ	ETF	194.69	194.77	194.66	194.66	3170.0
2019-07-29 18:00:00	QQQ	ETF	194.68	194.85	194.68	194.84	17365.0
2019-07-29 19:00:00	QQQ	ETF	194.85	194.88	194.8	194.86	13214.0
2019-07-29 04:00:00	IWM	ETF	157.02	157.02	157.02	157.02	100.0
2019-07-29 06:00:00	IWM	ETF	157.08	157.08	157.04	157.04	525.0
2019-07-29 07:00:00	IWM	ETF	157.05	157.25	157.05	157.25	4500.0
2019-07-29 08:00:00	IWM	ETF	157.07	157.22	157.07	157.14	11112.0
2019-07-29 09:00:00	IWM	ETF	157.15	157.36	156.2	156.25	2576350.0
2019-07-29 10:00:00	IWM	ETF	156.245	156.33	155.6	156.08	2785441.0
2019-07-29 11:00:00	IWM	ETF	156.11	156.23	155.79	156.172	806852.0
2019-07-29 12:00:00	IWM	ETF	156.1501	156.18	155.83	156.11	634744.0
2019-07-29 13:00:00	IWM	ETF	156.11	156.15	155.75	155.905	751344.0
2019-07-29 14:00:00	IWM	ETF	155.91	156.19	155.81	155.895	655358.0
2019-07-29 15:00:00	IWM	ETF	155.89	156.18	155.79	156.14	2728538.0
2019-07-29 16:00:00	IWM	ETF	156.13	156.2	155.95	156.2	844118.0
2019-07-29 17:00:00	IWM	ETF	156.2	156.2	156.19	156.19	1800.0
2019-07-29 18:00:00	IWM	ETF	156.19	156.3	156.19	156.3	2600.0
2019-07-29 19:00:00	IWM	ETF	156.28	156.32	156.28	156.29	3250.0
2019-07-29 04:00:00	DIA	ETF	271.68	271.7	271.68	271.68	500.0
2019-07-29 05:00:00	DIA	ETF	271.6	271.6	271.6	271.6	100.0
2019-07-29 06:00:00	DIA	ETF	271.63	271.68	271.63	271.68	225.0

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

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