PREVIEW / etf_1hour / 2021-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-15.parquet
  size:    429 KB
  rows:    14,818

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-03-15 04:00:00	SPY	ETF	393.86	395.0	393.78	394.87	16413.0
2021-03-15 05:00:00	SPY	ETF	395.02	395.45	395.0	395.23	14965.0
2021-03-15 06:00:00	SPY	ETF	395.14	395.22	394.56	394.84	38562.0
2021-03-15 07:00:00	SPY	ETF	394.82	394.93	394.35	394.44	91604.0
2021-03-15 08:00:00	SPY	ETF	394.6699	395.1896	393.4	393.82	293632.0
2021-03-15 09:00:00	SPY	ETF	393.85	394.675	393.67	393.989	6236760.0
2021-03-15 10:00:00	SPY	ETF	393.98	394.13	393.33	393.95	6815806.0
2021-03-15 11:00:00	SPY	ETF	393.95	394.17	392.03	393.075	8712013.0
2021-03-15 12:00:00	SPY	ETF	393.07	394.18	392.97	394.159	5214201.0
2021-03-15 13:00:00	SPY	ETF	394.16	394.6599	393.88	394.65	3520384.0
2021-03-15 14:00:00	SPY	ETF	394.659	395.51	394.651	395.23	5642565.0
2021-03-15 15:00:00	SPY	ETF	395.23	396.685	394.5	396.47	14785329.0
2021-03-15 16:00:00	SPY	ETF	396.47	396.73	396.3	396.38	4708041.0
2021-03-15 17:00:00	SPY	ETF	396.42	396.57	396.28	396.45	138758.0
2021-03-15 18:00:00	SPY	ETF	396.45	396.45	395.91	395.99	177003.0
2021-03-15 19:00:00	SPY	ETF	395.93	396.15	395.88	395.92	40537.0
2021-03-15 04:00:00	QQQ	ETF	314.56	316.04	314.34	316.0	39127.0
2021-03-15 05:00:00	QQQ	ETF	316.08	316.91	316.08	316.63	29215.0
2021-03-15 06:00:00	QQQ	ETF	316.63	316.69	315.81	316.32	66090.0
2021-03-15 07:00:00	QQQ	ETF	316.3	316.57	315.25	315.48	243905.0
2021-03-15 08:00:00	QQQ	ETF	316.18	316.5804	313.99	315.29	245174.0
2021-03-15 09:00:00	QQQ	ETF	315.24	316.59	314.52	316.08	6355136.0
2021-03-15 10:00:00	QQQ	ETF	316.07	316.9	314.77	316.39	5862294.0
2021-03-15 11:00:00	QQQ	ETF	316.38	316.7	314.095	315.34	4910276.0
2021-03-15 12:00:00	QQQ	ETF	315.32	316.28	315.17	316.04	3089178.0
2021-03-15 13:00:00	QQQ	ETF	316.07	316.65	315.62	316.53	1996135.0
2021-03-15 14:00:00	QQQ	ETF	316.53	317.755	316.53	317.695	3474277.0
2021-03-15 15:00:00	QQQ	ETF	317.71	319.0	317.0	318.88	6951332.0
2021-03-15 16:00:00	QQQ	ETF	318.87	319.35	318.7	318.96	1402903.0
2021-03-15 17:00:00	QQQ	ETF	318.91	319.12	318.19	319.0	120734.0
2021-03-15 18:00:00	QQQ	ETF	319.04	319.13	318.56	318.7	105928.0
2021-03-15 19:00:00	QQQ	ETF	318.72	318.92	318.5	318.55	95352.0
2021-03-15 04:00:00	IWM	ETF	234.44	234.95	234.41	234.95	9984.0
2021-03-15 05:00:00	IWM	ETF	235.0	235.38	234.89	235.2	6862.0
2021-03-15 06:00:00	IWM	ETF	235.09	235.09	233.41	233.84	52938.0
2021-03-15 07:00:00	IWM	ETF	233.85	233.85	233.15	233.28	135753.0
2021-03-15 08:00:00	IWM	ETF	233.4899	234.78	231.92	232.66	207876.0
2021-03-15 09:00:00	IWM	ETF	232.71	233.73	232.64	233.0	2406046.0
2021-03-15 10:00:00	IWM	ETF	232.98	234.24	231.91	233.68	2614955.0
2021-03-15 11:00:00	IWM	ETF	233.68	234.02	231.98	233.09	2070676.0
2021-03-15 12:00:00	IWM	ETF	233.07	234.01	232.99	233.905	1662069.0
2021-03-15 13:00:00	IWM	ETF	233.905	234.0982	233.67	234.09	1415006.0
2021-03-15 14:00:00	IWM	ETF	234.08	234.32	233.775	234.01	1399635.0
2021-03-15 15:00:00	IWM	ETF	233.99	234.53	233.12	234.4402	2904682.0
2021-03-15 16:00:00	IWM	ETF	234.4401	234.69	234.1999	234.42	1023487.0
2021-03-15 17:00:00	IWM	ETF	234.42	234.42	234.12	234.17	85285.0
2021-03-15 18:00:00	IWM	ETF	234.12	234.15	233.6901	233.76	43109.0
2021-03-15 19:00:00	IWM	ETF	233.73	233.88	233.58	233.58	24496.0
2021-03-15 04:00:00	DIA	ETF	328.97	329.55	328.97	329.55	6420.0
2021-03-15 05:00:00	DIA	ETF	329.55	329.83	329.55	329.76	1429.0

> showing 50 of 14,818 rows — these rows as CSV

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