PREVIEW / etf_1hour / 2020-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-25.parquet
  size:    394 KB
  rows:    12,956

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-25 04:00:00	SPY	ETF	324.2	324.57	323.33	323.33	83028.0
2020-02-25 05:00:00	SPY	ETF	323.35	323.55	321.92	322.85	122276.0
2020-02-25 06:00:00	SPY	ETF	322.69	323.75	322.41	323.23	223238.0
2020-02-25 07:00:00	SPY	ETF	323.23	324.34	322.8	324.18	566154.0
2020-02-25 08:00:00	SPY	ETF	324.19	325.53	322.42	324.05	1629898.0
2020-02-25 09:00:00	SPY	ETF	324.05	324.61	322.04	323.14	13760799.0
2020-02-25 10:00:00	SPY	ETF	323.12	323.57	318.45	319.82	26758078.0
2020-02-25 11:00:00	SPY	ETF	319.82	320.235	317.53	319.42	20118406.0
2020-02-25 12:00:00	SPY	ETF	319.42	319.68	316.97	317.09	14428585.0
2020-02-25 13:00:00	SPY	ETF	317.08	317.74	315.05	315.085	20778561.0
2020-02-25 14:00:00	SPY	ETF	315.09	315.23	312.08	314.16	46900375.0
2020-02-25 15:00:00	SPY	ETF	314.18	322.4158	311.69	312.7	51416821.0
2020-02-25 16:00:00	SPY	ETF	312.69	322.4158	312.39	313.73	12218180.0
2020-02-25 17:00:00	SPY	ETF	313.58	313.85	312.65	313.14	4334672.0
2020-02-25 18:00:00	SPY	ETF	313.2	315.21	313.2	315.0	977520.0
2020-02-25 19:00:00	SPY	ETF	315.03	315.12	313.38	313.43	342248.0
2020-02-25 04:00:00	QQQ	ETF	223.15	223.65	222.5	222.5	69283.0
2020-02-25 05:00:00	QQQ	ETF	222.5	222.82	221.1	222.0	160594.0
2020-02-25 06:00:00	QQQ	ETF	221.7	222.85	221.53	222.53	186712.0
2020-02-25 07:00:00	QQQ	ETF	222.53	223.66	222.2	223.51	421230.0
2020-02-25 08:00:00	QQQ	ETF	222.5801	224.68	221.39	223.39	726387.0
2020-02-25 09:00:00	QQQ	ETF	223.34	223.9879	221.63	222.53	7588339.0
2020-02-25 10:00:00	QQQ	ETF	222.52	222.89	218.97	220.02	12615104.0
2020-02-25 11:00:00	QQQ	ETF	219.98	220.42	217.92	220.18	13133426.0
2020-02-25 12:00:00	QQQ	ETF	220.18	220.51	218.4552	218.61	5968470.0
2020-02-25 13:00:00	QQQ	ETF	218.59	219.16	217.15	217.2	7455782.0
2020-02-25 14:00:00	QQQ	ETF	217.153	217.3	215.0333	216.74	13770296.0
2020-02-25 15:00:00	QQQ	ETF	216.735	217.98	214.74	215.45	17889170.0
2020-02-25 16:00:00	QQQ	ETF	215.44	216.77	215.25	216.28	2451659.0
2020-02-25 17:00:00	QQQ	ETF	216.35	216.52	215.37	215.84	457434.0
2020-02-25 18:00:00	QQQ	ETF	215.74	217.51	215.74	217.36	371504.0
2020-02-25 19:00:00	QQQ	ETF	217.45	217.46	215.8	216.17	680336.0
2020-02-25 04:00:00	IWM	ETF	162.69	162.69	162.54	162.54	3800.0
2020-02-25 05:00:00	IWM	ETF	162.54	162.54	161.99	162.29	9800.0
2020-02-25 06:00:00	IWM	ETF	162.13	162.69	162.04	162.29	56383.0
2020-02-25 07:00:00	IWM	ETF	162.43	162.87	162.28	162.81	123975.0
2020-02-25 08:00:00	IWM	ETF	162.3401	163.03	162.15	162.57	193630.0
2020-02-25 09:00:00	IWM	ETF	162.47	162.76	160.88	161.24	2493480.0
2020-02-25 10:00:00	IWM	ETF	161.235	161.454	158.64	159.53	4695700.0
2020-02-25 11:00:00	IWM	ETF	159.53	159.775	158.49	159.13	5094506.0
2020-02-25 12:00:00	IWM	ETF	159.12	159.32	157.77	157.82	3131006.0
2020-02-25 13:00:00	IWM	ETF	157.8	158.16	157.025	157.04	5172094.0
2020-02-25 14:00:00	IWM	ETF	157.045	157.34	155.96	157.12	6280008.0
2020-02-25 15:00:00	IWM	ETF	157.13	157.9	156.1392	156.4	6747758.0
2020-02-25 16:00:00	IWM	ETF	156.39	162.0379	156.21	156.92	1686944.0
2020-02-25 17:00:00	IWM	ETF	157.09	157.09	156.31	156.51	178984.0
2020-02-25 18:00:00	IWM	ETF	156.78	157.6	156.78	157.6	33187.0
2020-02-25 19:00:00	IWM	ETF	157.6	157.71	156.54	156.81	521616.0
2020-02-25 04:00:00	DIA	ETF	280.29	280.29	280.05	280.21	1485.0
2020-02-25 05:00:00	DIA	ETF	279.29	280.05	279.29	280.05	1800.0

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

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