PREVIEW / etf_1hour / 2019-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-19.parquet
  size:    331 KB
  rows:    10,977

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-02-19 04:00:00	SPY	ETF	277.56	277.56	276.97	277.02	24778.0
2019-02-19 05:00:00	SPY	ETF	277.03	277.22	277.03	277.13	10513.0
2019-02-19 06:00:00	SPY	ETF	277.12	277.14	276.56	276.75	66508.0
2019-02-19 07:00:00	SPY	ETF	276.7	277.0	276.57	276.85	281206.0
2019-02-19 08:00:00	SPY	ETF	276.6501	277.58	276.59	276.75	327293.0
2019-02-19 09:00:00	SPY	ETF	276.74	277.38	276.47	277.32	5956860.0
2019-02-19 10:00:00	SPY	ETF	277.325	277.63	277.05	277.21	7700377.0
2019-02-19 11:00:00	SPY	ETF	277.205	278.24	277.205	278.22	7065406.0
2019-02-19 12:00:00	SPY	ETF	278.23	278.24	277.9	277.9979	3483158.0
2019-02-19 13:00:00	SPY	ETF	277.9987	278.03	277.74	277.95	4079164.0
2019-02-19 14:00:00	SPY	ETF	277.95	278.58	277.925	278.53	6779327.0
2019-02-19 15:00:00	SPY	ETF	278.535	278.57	277.71	277.85	16703661.0
2019-02-19 16:00:00	SPY	ETF	277.84	277.9	277.47	277.65	5666266.0
2019-02-19 17:00:00	SPY	ETF	277.67	277.7	277.55	277.6	103669.0
2019-02-19 18:00:00	SPY	ETF	277.6	277.74	277.5	277.69	211500.0
2019-02-19 19:00:00	SPY	ETF	277.69	277.77	277.55	277.72	59841.0
2019-02-19 04:00:00	QQQ	ETF	172.22	172.3	171.86	171.87	16408.0
2019-02-19 05:00:00	QQQ	ETF	171.97	172.0	171.89	171.97	4045.0
2019-02-19 06:00:00	QQQ	ETF	171.94	171.94	171.48	171.58	35430.0
2019-02-19 07:00:00	QQQ	ETF	171.6	171.73	171.5	171.64	66338.0
2019-02-19 08:00:00	QQQ	ETF	171.55	172.34	171.47	171.56	99235.0
2019-02-19 09:00:00	QQQ	ETF	171.52	172.23	171.38	172.16	2349306.0
2019-02-19 10:00:00	QQQ	ETF	172.16	172.4	172.04	172.17	2058128.0
2019-02-19 11:00:00	QQQ	ETF	172.18	172.71	172.07	172.7	2612334.0
2019-02-19 12:00:00	QQQ	ETF	172.71	172.72	172.42	172.45	1256685.0
2019-02-19 13:00:00	QQQ	ETF	172.45	172.4631	172.29	172.3638	1106981.0
2019-02-19 14:00:00	QQQ	ETF	172.3666	172.8	172.3477	172.7801	1618258.0
2019-02-19 15:00:00	QQQ	ETF	172.78	172.79	172.16	172.27	3295381.0
2019-02-19 16:00:00	QQQ	ETF	172.28	172.29	171.995	172.17	1023836.0
2019-02-19 17:00:00	QQQ	ETF	172.16	172.16	172.13	172.14	12301.0
2019-02-19 18:00:00	QQQ	ETF	172.14	172.25	172.05	172.18	29316.0
2019-02-19 19:00:00	QQQ	ETF	172.19	172.31	172.13	172.25	40450.0
2019-02-19 04:00:00	IWM	ETF	156.0	156.0	155.69	155.79	3580.0
2019-02-19 05:00:00	IWM	ETF	155.76	155.83	155.76	155.83	3900.0
2019-02-19 06:00:00	IWM	ETF	155.7	155.7	155.44	155.44	1605.0
2019-02-19 07:00:00	IWM	ETF	155.46	155.62	155.45	155.59	36599.0
2019-02-19 08:00:00	IWM	ETF	155.6101	155.66	155.52	155.62	86008.0
2019-02-19 09:00:00	IWM	ETF	155.62	156.23	155.54	156.11	1659911.0
2019-02-19 10:00:00	IWM	ETF	156.12	156.44	155.88	156.16	2383064.0
2019-02-19 11:00:00	IWM	ETF	156.155	156.88	156.155	156.835	1829808.0
2019-02-19 12:00:00	IWM	ETF	156.83	156.93	156.65	156.81	1084555.0
2019-02-19 13:00:00	IWM	ETF	156.81	156.825	156.45	156.51	748028.0
2019-02-19 14:00:00	IWM	ETF	156.51	157.1	156.49	157.04	1323076.0
2019-02-19 15:00:00	IWM	ETF	157.04	157.05	156.59	156.65	2679605.0
2019-02-19 16:00:00	IWM	ETF	156.66	156.75	156.495	156.65	630622.0
2019-02-19 17:00:00	IWM	ETF	156.63	156.65	156.63	156.65	46500.0
2019-02-19 18:00:00	IWM	ETF	156.58	156.66	156.55	156.65	16535.0
2019-02-19 19:00:00	IWM	ETF	156.67	156.67	156.55	156.63	4300.0
2019-02-19 04:00:00	DIA	ETF	258.8	258.8	258.22	258.25	2350.0
2019-02-19 05:00:00	DIA	ETF	258.32	258.4	258.32	258.4	584.0

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

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