PREVIEW / etf_1hour / 2019-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-25.parquet
  size:    327 KB
  rows:    10,856

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-25 04:00:00	SPY	ETF	301.5	301.58	301.44	301.55	12195.0
2019-07-25 05:00:00	SPY	ETF	301.5	301.58	301.5	301.54	11419.0
2019-07-25 06:00:00	SPY	ETF	301.58	301.58	301.2	301.33	18233.0
2019-07-25 07:00:00	SPY	ETF	301.32	301.96	301.24	301.95	570362.0
2019-07-25 08:00:00	SPY	ETF	301.96	302.03	301.31	301.58	503893.0
2019-07-25 09:00:00	SPY	ETF	301.57	301.57	299.72	300.01	7494111.0
2019-07-25 10:00:00	SPY	ETF	300.005	300.88	299.92	300.65	7224979.0
2019-07-25 11:00:00	SPY	ETF	300.64	300.885	299.795	300.02	3859435.0
2019-07-25 12:00:00	SPY	ETF	300.02	300.1	299.11	299.57	5602399.0
2019-07-25 13:00:00	SPY	ETF	299.56	300.16	299.22	299.66	4608988.0
2019-07-25 14:00:00	SPY	ETF	299.65	300.3	299.52	299.6801	3848684.0
2019-07-25 15:00:00	SPY	ETF	299.68	300.12	299.33	299.9702	11302334.0
2019-07-25 16:00:00	SPY	ETF	299.95	300.2	299.62	299.84	6626853.0
2019-07-25 17:00:00	SPY	ETF	299.9	300.13	299.65	300.05	131076.0
2019-07-25 18:00:00	SPY	ETF	300.02	300.15	299.9	300.02	109559.0
2019-07-25 19:00:00	SPY	ETF	300.02	300.19	300.0	300.18	10323.0
2019-07-25 04:00:00	QQQ	ETF	194.97	195.13	194.95	195.13	21593.0
2019-07-25 05:00:00	QQQ	ETF	195.14	195.17	194.98	195.05	67798.0
2019-07-25 06:00:00	QQQ	ETF	195.04	195.05	194.75	194.82	24047.0
2019-07-25 07:00:00	QQQ	ETF	194.83	195.3	194.78	195.27	675451.0
2019-07-25 08:00:00	QQQ	ETF	195.29	195.36	194.8299	194.94	186398.0
2019-07-25 09:00:00	QQQ	ETF	194.93	194.93	193.24	193.6627	3449283.0
2019-07-25 10:00:00	QQQ	ETF	193.66	194.2101	193.22	193.99	3281750.0
2019-07-25 11:00:00	QQQ	ETF	193.98	194.17	193.45	193.66	1513634.0
2019-07-25 12:00:00	QQQ	ETF	193.67	193.74	192.93	193.2097	2025444.0
2019-07-25 13:00:00	QQQ	ETF	193.19	193.53	192.99	193.14	2094077.0
2019-07-25 14:00:00	QQQ	ETF	193.14	193.69	193.14	193.3	1750080.0
2019-07-25 15:00:00	QQQ	ETF	193.29	193.5621	193.04	193.27	3859748.0
2019-07-25 16:00:00	QQQ	ETF	193.27	194.38	192.59	194.1	1647409.0
2019-07-25 17:00:00	QQQ	ETF	194.04	194.46	194.0	194.38	166608.0
2019-07-25 18:00:00	QQQ	ETF	194.43	194.5	194.28	194.31	98409.0
2019-07-25 19:00:00	QQQ	ETF	194.31	194.39	194.24	194.36	39124.0
2019-07-25 04:00:00	IWM	ETF	157.43	157.45	157.42	157.43	1400.0
2019-07-25 05:00:00	IWM	ETF	157.47	157.47	157.47	157.47	400.0
2019-07-25 06:00:00	IWM	ETF	157.31	157.33	157.31	157.33	1400.0
2019-07-25 07:00:00	IWM	ETF	157.33	157.7	157.29	157.7	40005.0
2019-07-25 08:00:00	IWM	ETF	157.35	157.79	157.29	157.45	65815.0
2019-07-25 09:00:00	IWM	ETF	157.43	157.43	156.22	156.56	3142350.0
2019-07-25 10:00:00	IWM	ETF	156.57	156.87	156.33	156.405	2141218.0
2019-07-25 11:00:00	IWM	ETF	156.41	156.69	156.005	156.2	1709160.0
2019-07-25 12:00:00	IWM	ETF	156.2	156.21	155.19	155.68	2277137.0
2019-07-25 13:00:00	IWM	ETF	155.69	155.81	155.3	155.57	1236213.0
2019-07-25 14:00:00	IWM	ETF	155.58	155.85	155.32	155.39	770856.0
2019-07-25 15:00:00	IWM	ETF	155.38	155.48	155.09	155.33	2956439.0
2019-07-25 16:00:00	IWM	ETF	155.32	155.48	155.16	155.16	1187299.0
2019-07-25 17:00:00	IWM	ETF	155.19	155.48	155.15	155.3	2786.0
2019-07-25 18:00:00	IWM	ETF	155.26	155.27	155.17	155.26	9063.0
2019-07-25 19:00:00	IWM	ETF	155.31	155.39	155.31	155.38	7700.0
2019-07-25 06:00:00	DIA	ETF	273.05	273.05	273.05	273.05	100.0
2019-07-25 07:00:00	DIA	ETF	273.15	273.5	273.0	273.5	2510.0

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

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