PREVIEW / etf_1hour / 2021-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-11.parquet
  size:    402 KB
  rows:    13,982

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-06-11 04:00:00	SPY	ETF	423.54	423.8	423.51	423.8	2300.0
2021-06-11 05:00:00	SPY	ETF	423.79	423.79	423.69	423.74	7376.0
2021-06-11 06:00:00	SPY	ETF	423.69	424.49	423.68	424.49	20024.0
2021-06-11 07:00:00	SPY	ETF	424.48	424.51	424.0	424.11	54020.0
2021-06-11 08:00:00	SPY	ETF	424.4199	424.4904	423.72	424.3	236956.0
2021-06-11 09:00:00	SPY	ETF	424.29	424.49	423.79	423.98	3574507.0
2021-06-11 10:00:00	SPY	ETF	423.97	424.26	423.2209	423.37	5139536.0
2021-06-11 11:00:00	SPY	ETF	423.35	423.62	423.025	423.355	3586056.0
2021-06-11 12:00:00	SPY	ETF	423.36	423.455	422.82	423.19	2734290.0
2021-06-11 13:00:00	SPY	ETF	423.1801	423.535	423.02	423.48	2657202.0
2021-06-11 14:00:00	SPY	ETF	423.485	423.85	423.485	423.77	2687807.0
2021-06-11 15:00:00	SPY	ETF	423.7781	424.41	423.41	424.32	10054773.0
2021-06-11 16:00:00	SPY	ETF	424.32	424.43	424.12	424.27	3690091.0
2021-06-11 17:00:00	SPY	ETF	424.13	424.42	424.13	424.42	95055.0
2021-06-11 18:00:00	SPY	ETF	424.36	424.4	424.32	424.4	4019.0
2021-06-11 19:00:00	SPY	ETF	424.4	424.45	424.37	424.41	31098.0
2021-06-11 04:00:00	QQQ	ETF	340.14	340.53	340.11	340.52	28680.0
2021-06-11 05:00:00	QQQ	ETF	340.45	340.45	340.22	340.33	15125.0
2021-06-11 06:00:00	QQQ	ETF	340.2	341.25	340.15	341.24	46326.0
2021-06-11 07:00:00	QQQ	ETF	341.2	341.27	340.79	340.79	93995.0
2021-06-11 08:00:00	QQQ	ETF	340.4996	341.2404	340.1304	340.659	205701.0
2021-06-11 09:00:00	QQQ	ETF	340.64	340.98	339.92	340.565	3044444.0
2021-06-11 10:00:00	QQQ	ETF	340.56	340.97	339.865	340.2218	4023482.0
2021-06-11 11:00:00	QQQ	ETF	340.23	340.72	339.69	340.335	2536789.0
2021-06-11 12:00:00	QQQ	ETF	340.34	340.565	340.07	340.37	1220087.0
2021-06-11 13:00:00	QQQ	ETF	340.37	340.59	340.05	340.5	1139677.0
2021-06-11 14:00:00	QQQ	ETF	340.5	340.935	340.5	340.765	1266089.0
2021-06-11 15:00:00	QQQ	ETF	340.76	341.25	340.4	341.21	2772824.0
2021-06-11 16:00:00	QQQ	ETF	341.21	341.3	341.07	341.15	789992.0
2021-06-11 17:00:00	QQQ	ETF	341.19	341.3	341.0	341.24	45648.0
2021-06-11 18:00:00	QQQ	ETF	341.24	341.33	341.24	341.24	14010.0
2021-06-11 19:00:00	QQQ	ETF	341.25	341.4299	341.24	341.4	21165.0
2021-06-11 04:00:00	IWM	ETF	229.38	229.66	229.35	229.66	2919.0
2021-06-11 05:00:00	IWM	ETF	229.67	229.67	229.64	229.64	1790.0
2021-06-11 06:00:00	IWM	ETF	229.74	230.06	229.7	229.92	9954.0
2021-06-11 07:00:00	IWM	ETF	230.08	230.17	229.77	229.82	21849.0
2021-06-11 08:00:00	IWM	ETF	230.1599	230.48	229.92	230.44	78042.0
2021-06-11 09:00:00	IWM	ETF	230.43	231.41	230.18	231.23	2306530.0
2021-06-11 10:00:00	IWM	ETF	231.22	231.39	230.57	230.72	2147651.0
2021-06-11 11:00:00	IWM	ETF	230.73	230.745	230.07	230.62	1455806.0
2021-06-11 12:00:00	IWM	ETF	230.63	231.1	230.27	231.09	1467222.0
2021-06-11 13:00:00	IWM	ETF	231.09	231.3686	230.935	231.27	1613030.0
2021-06-11 14:00:00	IWM	ETF	231.26	231.39	230.98	231.11	1165818.0
2021-06-11 15:00:00	IWM	ETF	231.1098	231.8	230.96	231.76	2553470.0
2021-06-11 16:00:00	IWM	ETF	231.7	231.82	231.51	231.78	835576.0
2021-06-11 17:00:00	IWM	ETF	231.79	231.85	231.7	231.71	1470.0
2021-06-11 18:00:00	IWM	ETF	231.75	231.86	231.75	231.8	1200.0
2021-06-11 19:00:00	IWM	ETF	231.85	231.98	231.72	231.75	7134.0
2021-06-11 04:00:00	DIA	ETF	345.11	345.42	345.08	345.32	5300.0
2021-06-11 06:00:00	DIA	ETF	345.53	346.0	345.53	346.0	2425.0

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

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