PREVIEW / etf_1hour / 2020-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-26.parquet
  size:    375 KB
  rows:    12,745

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-26 04:00:00	SPY	ETF	344.4	344.7	344.14	344.48	14555.0
2020-08-26 05:00:00	SPY	ETF	344.49	344.6	344.25	344.32	23681.0
2020-08-26 06:00:00	SPY	ETF	344.32	344.5	344.26	344.5	20068.0
2020-08-26 07:00:00	SPY	ETF	344.52	344.65	344.3	344.35	160502.0
2020-08-26 08:00:00	SPY	ETF	344.6201	344.6299	344.05	344.46	212769.0
2020-08-26 09:00:00	SPY	ETF	344.43	344.99	344.17	344.66	4191913.0
2020-08-26 10:00:00	SPY	ETF	344.675	345.33	344.45	345.24	5181499.0
2020-08-26 11:00:00	SPY	ETF	345.24	346.089	345.08	345.995	4776531.0
2020-08-26 12:00:00	SPY	ETF	345.993	347.025	345.895	346.61	6060045.0
2020-08-26 13:00:00	SPY	ETF	346.6083	347.03	346.6	347.02	5997417.0
2020-08-26 14:00:00	SPY	ETF	347.0267	347.86	346.36	346.53	6686538.0
2020-08-26 15:00:00	SPY	ETF	346.5367	347.81	346.3	347.56	11305325.0
2020-08-26 16:00:00	SPY	ETF	347.55	348.36	346.8321	348.08	4914582.0
2020-08-26 17:00:00	SPY	ETF	348.07	348.07	347.91	347.95	119928.0
2020-08-26 18:00:00	SPY	ETF	347.99	348.05	347.5	347.6099	102436.0
2020-08-26 19:00:00	SPY	ETF	347.63	347.89	347.53	347.77	72175.0
2020-08-26 04:00:00	QQQ	ETF	286.47	287.03	286.29	286.93	43546.0
2020-08-26 05:00:00	QQQ	ETF	286.98	287.13	286.72	286.78	17613.0
2020-08-26 06:00:00	QQQ	ETF	286.83	287.23	286.75	287.23	24549.0
2020-08-26 07:00:00	QQQ	ETF	287.17	287.47	287.02	287.1	166690.0
2020-08-26 08:00:00	QQQ	ETF	287.4301	287.4301	286.24	286.69	497991.0
2020-08-26 09:00:00	QQQ	ETF	286.742	287.8	286.72	287.55	3797012.0
2020-08-26 10:00:00	QQQ	ETF	287.55	288.91	287.18	288.78	4919932.0
2020-08-26 11:00:00	QQQ	ETF	288.79	290.24	288.73	290.09	3764126.0
2020-08-26 12:00:00	QQQ	ETF	290.08	291.52	289.79	290.38	4640753.0
2020-08-26 13:00:00	QQQ	ETF	290.38	291.45	290.38	291.435	2663889.0
2020-08-26 14:00:00	QQQ	ETF	291.44	291.949	289.53	289.95	5107416.0
2020-08-26 15:00:00	QQQ	ETF	289.945	292.22	289.64	291.88	6607216.0
2020-08-26 16:00:00	QQQ	ETF	291.9	292.75	291.71	292.38	1423132.0
2020-08-26 17:00:00	QQQ	ETF	292.35	292.35	291.96	292.22	51818.0
2020-08-26 18:00:00	QQQ	ETF	292.28	292.28	291.81	291.86	90204.0
2020-08-26 19:00:00	QQQ	ETF	291.89	292.08	291.69	291.95	112254.0
2020-08-26 04:00:00	IWM	ETF	156.38	156.5	156.1	156.38	9412.0
2020-08-26 05:00:00	IWM	ETF	156.3	156.4	156.1	156.19	18549.0
2020-08-26 06:00:00	IWM	ETF	156.14	156.18	156.06	156.06	3184.0
2020-08-26 07:00:00	IWM	ETF	156.2	156.25	155.9	155.9	94887.0
2020-08-26 08:00:00	IWM	ETF	156.26	156.35	155.92	156.25	134801.0
2020-08-26 09:00:00	IWM	ETF	156.26	156.72	155.76	156.57	1543691.0
2020-08-26 10:00:00	IWM	ETF	156.57	156.77	155.69	155.76	1708510.0
2020-08-26 11:00:00	IWM	ETF	155.76	155.91	155.51	155.5977	1262506.0
2020-08-26 12:00:00	IWM	ETF	155.6	155.94	155.23	155.7803	1310263.0
2020-08-26 13:00:00	IWM	ETF	155.7762	155.94	155.58	155.605	756724.0
2020-08-26 14:00:00	IWM	ETF	155.605	155.74	155.23	155.265	1285142.0
2020-08-26 15:00:00	IWM	ETF	155.25	155.72	155.1822	155.39	2374507.0
2020-08-26 16:00:00	IWM	ETF	155.42	156.0	155.16	155.7	1101463.0
2020-08-26 17:00:00	IWM	ETF	155.7	155.7	155.65	155.7	446.0
2020-08-26 18:00:00	IWM	ETF	155.61	155.64	155.42	155.6	3580.0
2020-08-26 19:00:00	IWM	ETF	155.54	155.75	155.45	155.65	17760.0
2020-08-26 04:00:00	DIA	ETF	281.9	281.9	281.9	281.9	100.0
2020-08-26 05:00:00	DIA	ETF	282.05	282.05	281.95	281.97	1297.0

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

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