PREVIEW / etf_1hour / 2020-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-01.parquet
  size:    376 KB
  rows:    12,777

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-05-01 04:00:00	SPY	ETF	284.39	285.33	283.68	285.18	150953.0
2020-05-01 05:00:00	SPY	ETF	285.24	285.31	284.39	284.78	43227.0
2020-05-01 06:00:00	SPY	ETF	284.64	285.36	284.63	284.96	192264.0
2020-05-01 07:00:00	SPY	ETF	284.97	285.02	283.97	284.78	544389.0
2020-05-01 08:00:00	SPY	ETF	284.79	286.88	283.79	284.66	693351.0
2020-05-01 09:00:00	SPY	ETF	284.51	286.04	284.4	285.07	15278836.0
2020-05-01 10:00:00	SPY	ETF	285.08	285.96	284.16	285.08	20098256.0
2020-05-01 11:00:00	SPY	ETF	285.07	285.09	282.41	282.72	17276855.0
2020-05-01 12:00:00	SPY	ETF	282.72	283.02	281.61	282.31	13388420.0
2020-05-01 13:00:00	SPY	ETF	282.3	282.77	281.52	281.95	8976099.0
2020-05-01 14:00:00	SPY	ETF	281.96	290.6572	281.57	282.5473	10786908.0
2020-05-01 15:00:00	SPY	ETF	282.56	283.4	281.63	282.73	26529453.0
2020-05-01 16:00:00	SPY	ETF	282.78	283.06	281.96	282.09	8499882.0
2020-05-01 17:00:00	SPY	ETF	282.03	282.86	282.03	282.72	199982.0
2020-05-01 18:00:00	SPY	ETF	282.7	283.0	282.61	282.8699	70056.0
2020-05-01 19:00:00	SPY	ETF	282.85	282.94	282.77	282.9	55274.0
2020-05-01 04:00:00	QQQ	ETF	213.67	214.05	213.19	214.05	61411.0
2020-05-01 05:00:00	QQQ	ETF	214.05	214.11	213.64	213.88	35864.0
2020-05-01 06:00:00	QQQ	ETF	213.81	214.42	213.81	214.05	67169.0
2020-05-01 07:00:00	QQQ	ETF	214.05	214.39	213.41	214.32	183215.0
2020-05-01 08:00:00	QQQ	ETF	214.3	215.56	213.46	214.38	378209.0
2020-05-01 09:00:00	QQQ	ETF	214.3	215.79	214.17	215.46	5972420.0
2020-05-01 10:00:00	QQQ	ETF	215.48	216.67	214.95	215.48	6652915.0
2020-05-01 11:00:00	QQQ	ETF	215.425	215.46	212.92	213.1223	4679594.0
2020-05-01 12:00:00	QQQ	ETF	213.125	213.21	211.765	212.345	5879535.0
2020-05-01 13:00:00	QQQ	ETF	212.34	212.79	211.68	212.29	3382202.0
2020-05-01 14:00:00	QQQ	ETF	212.29	213.105	212.01	212.9601	3269813.0
2020-05-01 15:00:00	QQQ	ETF	212.98	213.69	212.055	212.64	8049184.0
2020-05-01 16:00:00	QQQ	ETF	212.64	212.9	212.32	212.47	965075.0
2020-05-01 17:00:00	QQQ	ETF	212.42	212.98	212.42	212.86	164427.0
2020-05-01 18:00:00	QQQ	ETF	212.8	212.94	212.66	212.85	17306.0
2020-05-01 19:00:00	QQQ	ETF	212.9	213.0	212.9	212.98	28332.0
2020-05-01 04:00:00	IWM	ETF	126.81	127.06	126.26	126.68	17271.0
2020-05-01 05:00:00	IWM	ETF	127.01	127.06	126.52	126.68	18775.0
2020-05-01 06:00:00	IWM	ETF	126.92	127.16	126.73	126.96	22223.0
2020-05-01 07:00:00	IWM	ETF	126.95	127.04	126.27	126.82	125697.0
2020-05-01 08:00:00	IWM	ETF	126.722	128.79	126.25	126.9	250511.0
2020-05-01 09:00:00	IWM	ETF	126.8	127.6	125.9415	126.2	5045458.0
2020-05-01 10:00:00	IWM	ETF	126.2	126.8	125.57	125.79	3957948.0
2020-05-01 11:00:00	IWM	ETF	125.78	125.79	123.29	123.84	4632535.0
2020-05-01 12:00:00	IWM	ETF	123.83	124.5399	123.431	123.95	4419917.0
2020-05-01 13:00:00	IWM	ETF	123.96	124.3128	123.5	124.0401	2589964.0
2020-05-01 14:00:00	IWM	ETF	124.04	124.83	123.835	124.48	2741198.0
2020-05-01 15:00:00	IWM	ETF	124.49	125.32	124.29	125.3	7653566.0
2020-05-01 16:00:00	IWM	ETF	125.3	125.46	124.75	124.91	5368659.0
2020-05-01 17:00:00	IWM	ETF	124.93	125.48	124.92	125.48	212306.0
2020-05-01 18:00:00	IWM	ETF	125.39	125.48	125.14	125.45	1019097.0
2020-05-01 19:00:00	IWM	ETF	125.27	125.48	125.27	125.48	4152.0
2020-05-01 04:00:00	DIA	ETF	238.84	239.18	238.37	239.13	6249.0
2020-05-01 05:00:00	DIA	ETF	239.08	239.2	238.64	238.96	900.0

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

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