PREVIEW / etf_1hour / 2020-08-07

all etf 1-hour files

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

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-07 04:00:00	SPY	ETF	334.02	334.02	333.05	333.26	24259.0
2020-08-07 05:00:00	SPY	ETF	333.22	333.22	332.46	332.87	19708.0
2020-08-07 06:00:00	SPY	ETF	332.73	333.19	332.58	333.15	135201.0
2020-08-07 07:00:00	SPY	ETF	333.26	333.36	333.06	333.1	191950.0
2020-08-07 08:00:00	SPY	ETF	333.3501	334.61	332.7	333.36	1424155.0
2020-08-07 09:00:00	SPY	ETF	333.36	334.085	332.8	333.92	4825620.0
2020-08-07 10:00:00	SPY	ETF	333.91	334.59	333.0584	334.38	5817989.0
2020-08-07 11:00:00	SPY	ETF	334.38	334.65	333.51	333.55	4365199.0
2020-08-07 12:00:00	SPY	ETF	333.54	334.57	333.37	333.86	4106474.0
2020-08-07 13:00:00	SPY	ETF	333.86	334.055	332.91	333.0203	6090356.0
2020-08-07 14:00:00	SPY	ETF	333.02	333.57	332.3	333.29	8177808.0
2020-08-07 15:00:00	SPY	ETF	333.29	334.88	332.845	334.55	16503516.0
2020-08-07 16:00:00	SPY	ETF	334.54	334.79	334.3	334.77	4678809.0
2020-08-07 17:00:00	SPY	ETF	334.78	334.78	334.37	334.43	188677.0
2020-08-07 18:00:00	SPY	ETF	334.43	334.63	334.3	334.55	58358.0
2020-08-07 19:00:00	SPY	ETF	334.5	334.67	334.43	334.53	15717.0
2020-08-07 04:00:00	QQQ	ETF	274.2	274.21	273.37	273.66	36278.0
2020-08-07 05:00:00	QQQ	ETF	273.49	273.5	273.02	273.48	27681.0
2020-08-07 06:00:00	QQQ	ETF	273.41	273.64	273.22	273.61	14221.0
2020-08-07 07:00:00	QQQ	ETF	273.65	273.81	273.56	273.66	92680.0
2020-08-07 08:00:00	QQQ	ETF	273.68	274.63	273.1	273.71	569226.0
2020-08-07 09:00:00	QQQ	ETF	273.76	274.64	273.44	274.4	3334000.0
2020-08-07 10:00:00	QQQ	ETF	274.41	274.8818	273.39	274.7	4366935.0
2020-08-07 11:00:00	QQQ	ETF	274.69	274.79	272.59	272.62	3291360.0
2020-08-07 12:00:00	QQQ	ETF	272.6111	273.37	271.7	271.72	4458964.0
2020-08-07 13:00:00	QQQ	ETF	271.71	271.78	270.02	270.2071	5911808.0
2020-08-07 14:00:00	QQQ	ETF	270.2	270.91	269.245	270.43	6125722.0
2020-08-07 15:00:00	QQQ	ETF	270.41	271.8	270.18	271.5	7484541.0
2020-08-07 16:00:00	QQQ	ETF	271.5	271.6	271.31	271.54	851098.0
2020-08-07 17:00:00	QQQ	ETF	271.59	271.59	271.41	271.47	17712.0
2020-08-07 18:00:00	QQQ	ETF	271.48	271.58	271.41	271.41	7745.0
2020-08-07 19:00:00	QQQ	ETF	271.48	271.66	271.36	271.37	14253.0
2020-08-07 04:00:00	IWM	ETF	153.66	153.67	153.2	153.22	5800.0
2020-08-07 05:00:00	IWM	ETF	153.15	153.25	152.9	153.25	16614.0
2020-08-07 06:00:00	IWM	ETF	153.15	153.36	153.1	153.33	28974.0
2020-08-07 07:00:00	IWM	ETF	153.4	153.5	153.1	153.17	62866.0
2020-08-07 08:00:00	IWM	ETF	153.15	154.22	153.0	153.6	187816.0
2020-08-07 09:00:00	IWM	ETF	153.47	154.3	153.15	154.16	1239728.0
2020-08-07 10:00:00	IWM	ETF	154.1	155.21	154.06	154.89	2937763.0
2020-08-07 11:00:00	IWM	ETF	154.9	155.77	154.87	154.9	1845711.0
2020-08-07 12:00:00	IWM	ETF	154.9	155.885	154.86	155.58	1353209.0
2020-08-07 13:00:00	IWM	ETF	155.58	155.63	154.98	155.03	1365158.0
2020-08-07 14:00:00	IWM	ETF	155.02	155.43	154.42	155.41	1788408.0
2020-08-07 15:00:00	IWM	ETF	155.41	156.25	155.085	156.2	4581460.0
2020-08-07 16:00:00	IWM	ETF	156.18	156.3	155.9	156.3	1139773.0
2020-08-07 17:00:00	IWM	ETF	156.3	156.3	156.13	156.17	13494.0
2020-08-07 18:00:00	IWM	ETF	156.15	156.27	156.15	156.2	5832.0
2020-08-07 19:00:00	IWM	ETF	156.15	156.28	156.15	156.17	5432.0
2020-08-07 04:00:00	DIA	ETF	273.5	273.5	272.72	272.72	2000.0
2020-08-07 05:00:00	DIA	ETF	272.52	272.58	272.25	272.58	1200.0

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

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