PREVIEW / etf_1hour / 2020-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-24.parquet
  size:    405 KB
  rows:    13,583

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-02-24 04:00:00	SPY	ETF	326.4	326.46	324.19	325.8	705764.0
2020-02-24 05:00:00	SPY	ETF	325.7	325.87	324.36	324.63	198833.0
2020-02-24 06:00:00	SPY	ETF	324.64	326.12	324.17	325.7	638007.0
2020-02-24 07:00:00	SPY	ETF	325.77	326.47	325.02	325.4	1507387.0
2020-02-24 08:00:00	SPY	ETF	326.2301	329.23	324.35	324.52	1792532.0
2020-02-24 09:00:00	SPY	ETF	324.52	325.65	322.86	325.34	21955707.0
2020-02-24 10:00:00	SPY	ETF	325.34	325.85	323.61	324.75	17411286.0
2020-02-24 11:00:00	SPY	ETF	324.745	324.92	323.03	323.51	14609901.0
2020-02-24 12:00:00	SPY	ETF	323.5	333.5623	322.17	322.37	15670703.0
2020-02-24 13:00:00	SPY	ETF	322.36	323.2	321.24	322.99	16653075.0
2020-02-24 14:00:00	SPY	ETF	322.98	324.88	322.07	324.7	16049662.0
2020-02-24 15:00:00	SPY	ETF	324.7	333.5623	322.4	322.41	34867784.0
2020-02-24 16:00:00	SPY	ETF	322.4	333.5623	321.9	322.53	14856535.0
2020-02-24 17:00:00	SPY	ETF	322.6	322.75	322.44	322.48	1497672.0
2020-02-24 18:00:00	SPY	ETF	322.5	323.94	321.35	323.84	544685.0
2020-02-24 19:00:00	SPY	ETF	323.74	324.65	323.58	324.63	335638.0
2020-02-24 04:00:00	QQQ	ETF	227.01	227.01	222.4	223.71	379631.0
2020-02-24 05:00:00	QQQ	ETF	223.7	223.83	222.73	222.92	199901.0
2020-02-24 06:00:00	QQQ	ETF	222.89	224.28	222.63	223.98	477177.0
2020-02-24 07:00:00	QQQ	ETF	224.01	224.87	223.65	223.92	1357148.0
2020-02-24 08:00:00	QQQ	ETF	223.93	226.47	223.26	223.39	1270223.0
2020-02-24 09:00:00	QQQ	ETF	223.39	223.935	220.26	223.7656	12074819.0
2020-02-24 10:00:00	QQQ	ETF	223.78	224.25	222.0533	223.05	9320830.0
2020-02-24 11:00:00	QQQ	ETF	223.03	223.17	221.505	222.0	7491121.0
2020-02-24 12:00:00	QQQ	ETF	221.99	222.27	220.96	221.43	6868793.0
2020-02-24 13:00:00	QQQ	ETF	221.41	221.98	220.44	221.84	7692317.0
2020-02-24 14:00:00	QQQ	ETF	221.84	223.49	220.98	223.36	6087930.0
2020-02-24 15:00:00	QQQ	ETF	223.36	223.83	221.38	221.39	9870579.0
2020-02-24 16:00:00	QQQ	ETF	221.38	230.3587	221.1	221.69	2506416.0
2020-02-24 17:00:00	QQQ	ETF	221.79	221.8	221.51	221.55	425152.0
2020-02-24 18:00:00	QQQ	ETF	221.55	230.3587	220.72	222.74	262846.0
2020-02-24 19:00:00	QQQ	ETF	222.74	223.43	222.53	223.42	392771.0
2020-02-24 04:00:00	IWM	ETF	163.03	163.03	161.89	162.7	25717.0
2020-02-24 05:00:00	IWM	ETF	162.67	162.71	162.19	162.19	48044.0
2020-02-24 06:00:00	IWM	ETF	162.25	162.99	162.04	162.94	165970.0
2020-02-24 07:00:00	IWM	ETF	162.93	163.25	162.51	162.76	99823.0
2020-02-24 08:00:00	IWM	ETF	162.91	164.34	162.3	162.36	154498.0
2020-02-24 09:00:00	IWM	ETF	162.36	162.53	161.53	162.46	4014972.0
2020-02-24 10:00:00	IWM	ETF	162.45	162.83	161.81	162.5	3623158.0
2020-02-24 11:00:00	IWM	ETF	162.48	162.53	161.65	161.89	1813036.0
2020-02-24 12:00:00	IWM	ETF	161.87	162.11	161.37	161.47	1931337.0
2020-02-24 13:00:00	IWM	ETF	161.46	162.09	161.095	162.02	2420264.0
2020-02-24 14:00:00	IWM	ETF	162.011	162.81	161.63	162.66	1662949.0
2020-02-24 15:00:00	IWM	ETF	162.65	162.905	161.89	161.96	4502007.0
2020-02-24 16:00:00	IWM	ETF	161.95	167.0623	161.48	162.11	1310644.0
2020-02-24 17:00:00	IWM	ETF	162.01	162.1	161.79	162.1	612900.0
2020-02-24 18:00:00	IWM	ETF	161.92	162.7	161.42	162.6	136226.0
2020-02-24 19:00:00	IWM	ETF	162.54	163.08	162.51	163.08	31630.0
2020-02-24 04:00:00	DIA	ETF	283.95	283.95	281.66	282.62	33815.0
2020-02-24 05:00:00	DIA	ETF	282.72	282.72	281.75	281.87	1450.0

> showing 50 of 13,583 rows — these rows as CSV

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