PREVIEW / etf_1hour / 2021-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-25.parquet
  size:    433 KB
  rows:    15,394

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-02-25 04:00:00	SPY	ETF	391.9	391.9	391.15	391.6	53746.0
2021-02-25 05:00:00	SPY	ETF	391.53	391.96	391.2	391.87	14427.0
2021-02-25 06:00:00	SPY	ETF	392.0	392.08	390.37	390.91	157534.0
2021-02-25 07:00:00	SPY	ETF	390.87	391.28	390.35	390.72	457770.0
2021-02-25 08:00:00	SPY	ETF	390.69	392.98	390.2	390.7	696424.0
2021-02-25 09:00:00	SPY	ETF	390.72	391.88	390.05	390.96	8585380.0
2021-02-25 10:00:00	SPY	ETF	390.97	391.01	387.565	389.0	19836663.0
2021-02-25 11:00:00	SPY	ETF	388.98	389.66	386.07	386.33	12996600.0
2021-02-25 12:00:00	SPY	ETF	386.33	386.8899	382.68	382.92	19636756.0
2021-02-25 13:00:00	SPY	ETF	382.91	385.0	381.76	384.13	19289895.0
2021-02-25 14:00:00	SPY	ETF	384.115	386.67	383.74	384.135	11541894.0
2021-02-25 15:00:00	SPY	ETF	384.13	384.66	380.7789	382.39	28300001.0
2021-02-25 16:00:00	SPY	ETF	382.4	383.79	381.7	381.89	5259792.0
2021-02-25 17:00:00	SPY	ETF	381.85	382.33	381.58	381.69	295096.0
2021-02-25 18:00:00	SPY	ETF	381.72	383.1	381.1	381.83	371708.0
2021-02-25 19:00:00	SPY	ETF	381.7	382.35	380.22	382.13	393401.0
2021-02-25 04:00:00	QQQ	ETF	323.14	323.14	321.52	322.15	128329.0
2021-02-25 05:00:00	QQQ	ETF	322.02	323.18	321.68	323.18	56183.0
2021-02-25 06:00:00	QQQ	ETF	323.38	323.47	320.55	321.15	403366.0
2021-02-25 07:00:00	QQQ	ETF	321.19	322.01	320.86	321.23	389533.0
2021-02-25 08:00:00	QQQ	ETF	321.44	325.41	320.6996	321.95	504506.0
2021-02-25 09:00:00	QQQ	ETF	321.86	324.03	320.79	322.3	7945926.0
2021-02-25 10:00:00	QQQ	ETF	322.32	322.39	318.34	320.18	13803224.0
2021-02-25 11:00:00	QQQ	ETF	320.1677	321.04	316.6	316.71	9078520.0
2021-02-25 12:00:00	QQQ	ETF	316.73	317.38	312.95	313.37	11985641.0
2021-02-25 13:00:00	QQQ	ETF	313.37	316.08	312.15	314.79	11994931.0
2021-02-25 14:00:00	QQQ	ETF	314.76	317.46	314.43	314.76	7463400.0
2021-02-25 15:00:00	QQQ	ETF	314.73	315.18	311.24	312.71	19419504.0
2021-02-25 16:00:00	QQQ	ETF	312.73	314.02	311.61	311.77	3358324.0
2021-02-25 17:00:00	QQQ	ETF	311.92	312.9	311.5	311.54	1384039.0
2021-02-25 18:00:00	QQQ	ETF	311.8	313.22	311.1	311.63	442494.0
2021-02-25 19:00:00	QQQ	ETF	311.58	312.14	309.76	311.42	480684.0
2021-02-25 04:00:00	IWM	ETF	228.47	228.64	228.06	228.24	28704.0
2021-02-25 05:00:00	IWM	ETF	228.22	228.49	228.06	228.47	39350.0
2021-02-25 06:00:00	IWM	ETF	228.57	228.57	227.29	227.55	68131.0
2021-02-25 07:00:00	IWM	ETF	227.51	227.67	226.99	227.1	115317.0
2021-02-25 08:00:00	IWM	ETF	227.08	228.33	226.74	227.15	186549.0
2021-02-25 09:00:00	IWM	ETF	227.07	227.585	226.39	226.89	3781377.0
2021-02-25 10:00:00	IWM	ETF	226.9154	226.95	223.48	224.39	5170155.0
2021-02-25 11:00:00	IWM	ETF	224.39	224.98	222.42	222.58	2907011.0
2021-02-25 12:00:00	IWM	ETF	222.53	222.77	218.955	219.13	4773425.0
2021-02-25 13:00:00	IWM	ETF	219.14	222.5299	218.63	221.68	5743099.0
2021-02-25 14:00:00	IWM	ETF	221.66	223.48	221.33	221.58	3444795.0
2021-02-25 15:00:00	IWM	ETF	221.55	222.03	218.01	218.51	10529133.0
2021-02-25 16:00:00	IWM	ETF	218.52	219.51	217.98	218.12	1654843.0
2021-02-25 17:00:00	IWM	ETF	218.3	218.61	217.85	218.1	67543.0
2021-02-25 18:00:00	IWM	ETF	218.18	219.02	217.4	218.41	552277.0
2021-02-25 19:00:00	IWM	ETF	218.33	218.4	216.0	217.57	91547.0
2021-02-25 04:00:00	DIA	ETF	319.07	320.09	319.07	319.97	2225.0
2021-02-25 05:00:00	DIA	ETF	320.16	320.4	320.08	320.4	5800.0

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

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