PREVIEW / etf_1hour / 2020-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-15.parquet
  size:    379 KB
  rows:    12,715

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-10-15 04:00:00	SPY	ETF	346.34	346.34	344.15	344.43	102289.0
2020-10-15 05:00:00	SPY	ETF	344.33	344.58	343.39	344.27	129493.0
2020-10-15 06:00:00	SPY	ETF	344.2	344.78	343.77	344.66	219121.0
2020-10-15 07:00:00	SPY	ETF	344.7	345.05	344.17	344.4	347271.0
2020-10-15 08:00:00	SPY	ETF	344.37	347.3	343.4	343.85	1119153.0
2020-10-15 09:00:00	SPY	ETF	343.83	345.65	343.13	345.65	7559068.0
2020-10-15 10:00:00	SPY	ETF	345.64	345.69	343.84	344.75	8461158.0
2020-10-15 11:00:00	SPY	ETF	344.74	346.36	344.0	345.57	7862285.0
2020-10-15 12:00:00	SPY	ETF	345.57	345.92	344.84	345.87	5128279.0
2020-10-15 13:00:00	SPY	ETF	345.8699	346.83	345.77	346.508	3767923.0
2020-10-15 14:00:00	SPY	ETF	346.52	347.03	346.265	346.92	5969180.0
2020-10-15 15:00:00	SPY	ETF	346.91	348.02	346.78	347.51	15123609.0
2020-10-15 16:00:00	SPY	ETF	347.51	347.75	347.38	347.53	3548274.0
2020-10-15 17:00:00	SPY	ETF	347.52	347.79	347.5	347.76	125056.0
2020-10-15 18:00:00	SPY	ETF	347.82	347.92	347.6	347.6	97801.0
2020-10-15 19:00:00	SPY	ETF	347.61	348.61	347.56	348.3	147900.0
2020-10-15 04:00:00	QQQ	ETF	289.49	289.49	286.63	287.24	147590.0
2020-10-15 05:00:00	QQQ	ETF	287.15	287.22	286.22	287.02	251809.0
2020-10-15 06:00:00	QQQ	ETF	287.2	288.33	287.0	288.11	273144.0
2020-10-15 07:00:00	QQQ	ETF	288.09	288.43	287.57	287.8	385007.0
2020-10-15 08:00:00	QQQ	ETF	287.85	290.36	287.01	287.74	525748.0
2020-10-15 09:00:00	QQQ	ETF	287.64	289.75	286.68	289.58	4928330.0
2020-10-15 10:00:00	QQQ	ETF	289.567	289.59	286.54	287.94	6722184.0
2020-10-15 11:00:00	QQQ	ETF	287.9305	289.16	286.94	288.28	4513029.0
2020-10-15 12:00:00	QQQ	ETF	288.2935	288.8	287.15	288.0299	3621566.0
2020-10-15 13:00:00	QQQ	ETF	288.02	288.84	287.43	288.69	2274041.0
2020-10-15 14:00:00	QQQ	ETF	288.6851	289.33	288.29	289.09	2735296.0
2020-10-15 15:00:00	QQQ	ETF	289.068	290.71	288.97	290.02	6235688.0
2020-10-15 16:00:00	QQQ	ETF	290.03	290.33	288.0	289.8	1310134.0
2020-10-15 17:00:00	QQQ	ETF	289.85	290.2	289.75	290.2	29721.0
2020-10-15 18:00:00	QQQ	ETF	290.11	290.38	290.01	290.01	58402.0
2020-10-15 19:00:00	QQQ	ETF	290.03	291.03	290.03	290.64	165317.0
2020-10-15 04:00:00	IWM	ETF	160.42	160.42	159.4	159.42	21789.0
2020-10-15 05:00:00	IWM	ETF	159.24	159.5	159.02	159.39	16492.0
2020-10-15 06:00:00	IWM	ETF	159.54	159.68	159.3	159.67	87634.0
2020-10-15 07:00:00	IWM	ETF	159.72	160.0	159.51	159.68	155380.0
2020-10-15 08:00:00	IWM	ETF	159.9899	159.9899	159.1899	159.27	186930.0
2020-10-15 09:00:00	IWM	ETF	159.29	160.12	158.81	159.88	2527118.0
2020-10-15 10:00:00	IWM	ETF	159.88	160.28	159.46	160.28	2678394.0
2020-10-15 11:00:00	IWM	ETF	160.29	161.89	160.07	161.35	2644247.0
2020-10-15 12:00:00	IWM	ETF	161.32	161.771	160.985	161.73	1567120.0
2020-10-15 13:00:00	IWM	ETF	161.73	162.66	161.61	162.4	2481759.0
2020-10-15 14:00:00	IWM	ETF	162.39	162.77	162.28	162.77	1586678.0
2020-10-15 15:00:00	IWM	ETF	162.76	163.18	162.56	162.77	3522190.0
2020-10-15 16:00:00	IWM	ETF	162.77	163.06	162.7	163.01	799482.0
2020-10-15 17:00:00	IWM	ETF	163.0	163.14	163.0	163.08	14239.0
2020-10-15 18:00:00	IWM	ETF	163.1	163.13	162.98	163.03	5320.0
2020-10-15 19:00:00	IWM	ETF	163.01	163.51	162.98	163.37	30240.0
2020-10-15 04:00:00	DIA	ETF	283.82	283.85	282.38	282.6	5606.0
2020-10-15 05:00:00	DIA	ETF	282.31	282.65	282.12	282.23	11292.0

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

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