PREVIEW / etf_1hour / 2021-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-11.parquet
  size:    429 KB
  rows:    15,305

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
2021-05-11 04:00:00	SPY	ETF	416.0	416.0	414.16	414.85	77290.0
2021-05-11 05:00:00	SPY	ETF	414.99	415.7	414.99	415.19	53344.0
2021-05-11 06:00:00	SPY	ETF	415.19	415.22	414.22	414.82	130281.0
2021-05-11 07:00:00	SPY	ETF	414.82	414.97	414.0	414.07	248392.0
2021-05-11 08:00:00	SPY	ETF	414.82	416.0	412.41	412.55	1042149.0
2021-05-11 09:00:00	SPY	ETF	412.5	414.89	412.04	414.8822	14339809.0
2021-05-11 10:00:00	SPY	ETF	414.9	415.27	410.06	411.83	21310229.0
2021-05-11 11:00:00	SPY	ETF	411.82	414.36	410.77	414.03	12327494.0
2021-05-11 12:00:00	SPY	ETF	414.03	414.45	412.043	412.5375	7479396.0
2021-05-11 13:00:00	SPY	ETF	412.52	414.735	412.355	414.2257	8740850.0
2021-05-11 14:00:00	SPY	ETF	414.23	414.78	413.14	414.1	9195272.0
2021-05-11 15:00:00	SPY	ETF	414.09	415.03	412.66	414.27	19731811.0
2021-05-11 16:00:00	SPY	ETF	414.27	414.69	413.39	413.69	3302245.0
2021-05-11 17:00:00	SPY	ETF	413.64	413.72	413.45	413.64	101901.0
2021-05-11 18:00:00	SPY	ETF	413.64	414.21	413.46	413.75	70729.0
2021-05-11 19:00:00	SPY	ETF	413.7	414.3	413.37	414.25	76618.0
2021-05-11 04:00:00	QQQ	ETF	321.8	322.0	320.72	321.56	126209.0
2021-05-11 05:00:00	QQQ	ETF	321.51	322.04	321.23	321.54	76355.0
2021-05-11 06:00:00	QQQ	ETF	321.68	321.68	320.86	321.44	96312.0
2021-05-11 07:00:00	QQQ	ETF	321.47	321.58	319.85	319.9	706546.0
2021-05-11 08:00:00	QQQ	ETF	319.9	323.45	318.92	319.03	1533501.0
2021-05-11 09:00:00	QQQ	ETF	319.03	323.59	318.57	323.58	10679794.0
2021-05-11 10:00:00	QQQ	ETF	323.6	323.77	320.06	322.16	12778484.0
2021-05-11 11:00:00	QQQ	ETF	322.14	324.91	321.02	324.44	8607534.0
2021-05-11 12:00:00	QQQ	ETF	324.44	325.24	323.01	323.6299	4922039.0
2021-05-11 13:00:00	QQQ	ETF	323.6301	325.98	323.5	325.15	4727863.0
2021-05-11 14:00:00	QQQ	ETF	325.15	326.1299	324.26	325.04	5175688.0
2021-05-11 15:00:00	QQQ	ETF	325.0	326.1	324.05	325.31	8645792.0
2021-05-11 16:00:00	QQQ	ETF	325.34	325.51	324.5	324.65	1266618.0
2021-05-11 17:00:00	QQQ	ETF	324.45	324.78	324.45	324.65	46203.0
2021-05-11 18:00:00	QQQ	ETF	324.67	325.1	324.67	324.88	120829.0
2021-05-11 19:00:00	QQQ	ETF	324.93	325.21	324.46	325.17	72485.0
2021-05-11 04:00:00	IWM	ETF	217.32	217.32	216.49	217.22	13411.0
2021-05-11 05:00:00	IWM	ETF	217.46	217.89	217.1	217.13	11241.0
2021-05-11 06:00:00	IWM	ETF	216.88	216.94	215.94	216.63	50966.0
2021-05-11 07:00:00	IWM	ETF	216.67	216.8	215.82	215.86	406364.0
2021-05-11 08:00:00	IWM	ETF	215.72	217.5	214.06	214.7	631677.0
2021-05-11 09:00:00	IWM	ETF	214.62	219.19	214.05	219.17	4787917.0
2021-05-11 10:00:00	IWM	ETF	219.17	219.18	215.3	217.08	7938289.0
2021-05-11 11:00:00	IWM	ETF	217.1	219.31	216.29	218.41	3810125.0
2021-05-11 12:00:00	IWM	ETF	218.44	219.01	217.33	217.86	2610947.0
2021-05-11 13:00:00	IWM	ETF	217.87	219.8299	217.74	219.55	2352711.0
2021-05-11 14:00:00	IWM	ETF	219.57	220.3888	218.81	219.15	3767816.0
2021-05-11 15:00:00	IWM	ETF	219.13	219.95	218.29	219.04	4831281.0
2021-05-11 16:00:00	IWM	ETF	218.96	219.32	218.38	218.65	943761.0
2021-05-11 17:00:00	IWM	ETF	218.57	218.75	218.5	218.69	5372.0
2021-05-11 18:00:00	IWM	ETF	218.69	218.87	218.51	218.71	75759.0
2021-05-11 19:00:00	IWM	ETF	218.61	219.16	218.41	219.12	22823.0
2021-05-11 04:00:00	DIA	ETF	346.32	346.34	345.87	345.88	57827.0
2021-05-11 05:00:00	DIA	ETF	345.79	346.8	345.79	346.27	12899.0

> showing 50 of 15,305 rows — these rows as CSV

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