PREVIEW / etf_1hour / 2020-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-10.parquet
  size:    374 KB
  rows:    12,732

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-08-10 04:00:00	SPY	ETF	335.06	335.14	334.43	335.03	36781.0
2020-08-10 05:00:00	SPY	ETF	335.05	335.29	334.94	335.16	16044.0
2020-08-10 06:00:00	SPY	ETF	335.07	335.25	334.95	335.05	44059.0
2020-08-10 07:00:00	SPY	ETF	335.01	335.03	334.62	334.84	110476.0
2020-08-10 08:00:00	SPY	ETF	334.86	335.15	334.62	334.97	161868.0
2020-08-10 09:00:00	SPY	ETF	334.96	335.59	334.68	335.11	4472564.0
2020-08-10 10:00:00	SPY	ETF	335.12	335.395	333.175	333.1999	6552798.0
2020-08-10 11:00:00	SPY	ETF	333.19	335.02	332.955	334.9175	5102108.0
2020-08-10 12:00:00	SPY	ETF	334.92	335.28	334.34	335.14	3117054.0
2020-08-10 13:00:00	SPY	ETF	335.15	335.44	334.91	335.09	3306833.0
2020-08-10 14:00:00	SPY	ETF	335.1	335.505	334.79	335.481	4521457.0
2020-08-10 15:00:00	SPY	ETF	335.48	335.77	334.88	335.55	11328922.0
2020-08-10 16:00:00	SPY	ETF	335.57	335.6	335.0067	335.33	4121089.0
2020-08-10 17:00:00	SPY	ETF	335.3	335.57	335.03	335.1	258273.0
2020-08-10 18:00:00	SPY	ETF	335.11	336.82	334.89	334.95	175954.0
2020-08-10 19:00:00	SPY	ETF	334.97	335.41	334.85	335.34	246910.0
2020-08-10 20:00:00	SPY	ETF	335.31	335.31	335.27	335.27	400.0
2020-08-10 04:00:00	QQQ	ETF	271.36	271.39	270.77	271.22	16518.0
2020-08-10 05:00:00	QQQ	ETF	271.12	271.4	271.12	271.34	15780.0
2020-08-10 06:00:00	QQQ	ETF	271.25	271.46	271.23	271.43	24220.0
2020-08-10 07:00:00	QQQ	ETF	271.4	271.58	271.12	271.58	85787.0
2020-08-10 08:00:00	QQQ	ETF	271.3099	271.8	271.18	271.67	237813.0
2020-08-10 09:00:00	QQQ	ETF	271.67	271.98	269.98	270.35	4230771.0
2020-08-10 10:00:00	QQQ	ETF	270.38	270.51	267.021	267.06	7251401.0
2020-08-10 11:00:00	QQQ	ETF	267.04	269.345	266.67	269.15	5340422.0
2020-08-10 12:00:00	QQQ	ETF	269.165	270.42	268.58	270.18	3235210.0
2020-08-10 13:00:00	QQQ	ETF	270.17	270.9	269.69	269.88	2218466.0
2020-08-10 14:00:00	QQQ	ETF	269.94	270.46	269.39	270.38	2008004.0
2020-08-10 15:00:00	QQQ	ETF	270.388	270.7098	269.42	270.28	3605728.0
2020-08-10 16:00:00	QQQ	ETF	270.29	270.57	270.0	270.31	508533.0
2020-08-10 17:00:00	QQQ	ETF	270.37	270.37	270.0	270.01	56150.0
2020-08-10 18:00:00	QQQ	ETF	270.01	270.14	269.87	269.9299	26750.0
2020-08-10 19:00:00	QQQ	ETF	269.88	270.23	269.81	270.2	167540.0
2020-08-10 04:00:00	IWM	ETF	156.66	156.66	156.21	156.59	15454.0
2020-08-10 05:00:00	IWM	ETF	156.63	156.91	156.63	156.79	7140.0
2020-08-10 06:00:00	IWM	ETF	156.83	156.88	156.7	156.75	5729.0
2020-08-10 07:00:00	IWM	ETF	156.72	156.73	156.45	156.57	63540.0
2020-08-10 08:00:00	IWM	ETF	156.56	156.8	156.5	156.77	52688.0
2020-08-10 09:00:00	IWM	ETF	156.79	157.89	156.6	157.87	3371384.0
2020-08-10 10:00:00	IWM	ETF	157.87	158.83	157.59	157.89	4452405.0
2020-08-10 11:00:00	IWM	ETF	157.89	158.65	157.84	158.53	1985152.0
2020-08-10 12:00:00	IWM	ETF	158.53	158.56	158.05	158.27	1465082.0
2020-08-10 13:00:00	IWM	ETF	158.29	158.48	157.92	158.095	1838328.0
2020-08-10 14:00:00	IWM	ETF	158.1	158.27	157.74	157.87	2080912.0
2020-08-10 15:00:00	IWM	ETF	157.86	158.28	157.55	157.805	3464287.0
2020-08-10 16:00:00	IWM	ETF	157.79	157.9	157.6	157.6	573929.0
2020-08-10 17:00:00	IWM	ETF	157.75	157.84	157.66	157.66	8349.0
2020-08-10 18:00:00	IWM	ETF	157.61	157.7	157.57	157.57	18026.0
2020-08-10 19:00:00	IWM	ETF	157.56	157.79	157.55	157.76	10525.0
2020-08-10 04:00:00	DIA	ETF	275.26	275.26	275.05	275.05	400.0

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

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