PREVIEW / etf_1hour / 2020-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-27.parquet
  size:    376 KB
  rows:    12,710

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-04-27 04:00:00	SPY	ETF	285.69	285.9	284.89	285.59	141276.0
2020-04-27 05:00:00	SPY	ETF	285.61	286.43	285.25	286.18	203028.0
2020-04-27 06:00:00	SPY	ETF	285.98	286.03	285.4	285.41	181877.0
2020-04-27 07:00:00	SPY	ETF	285.46	285.94	285.2	285.65	381103.0
2020-04-27 08:00:00	SPY	ETF	285.83	286.62	284.59	285.73	746038.0
2020-04-27 09:00:00	SPY	ETF	285.77	286.17	284.62	285.52	7100864.0
2020-04-27 10:00:00	SPY	ETF	285.52	286.41	285.16	285.69	10607915.0
2020-04-27 11:00:00	SPY	ETF	285.68	287.21	285.42	286.91	8938446.0
2020-04-27 12:00:00	SPY	ETF	286.91	287.35	286.42	287.07	7703246.0
2020-04-27 13:00:00	SPY	ETF	287.07	287.09	286.1	286.515	7263642.0
2020-04-27 14:00:00	SPY	ETF	286.51	287.6	286.51	287.36	7132593.0
2020-04-27 15:00:00	SPY	ETF	287.36	288.27	287.04	287.11	19046546.0
2020-04-27 16:00:00	SPY	ETF	287.11	287.53	286.75	286.91	7060179.0
2020-04-27 17:00:00	SPY	ETF	287.01	287.12	286.88	287.06	150105.0
2020-04-27 18:00:00	SPY	ETF	287.06	287.08	286.47	286.79	241401.0
2020-04-27 19:00:00	SPY	ETF	286.79	287.43	286.79	286.97	136102.0
2020-04-27 04:00:00	QQQ	ETF	216.55	216.65	215.98	216.56	31946.0
2020-04-27 05:00:00	QQQ	ETF	216.37	217.09	216.37	216.83	31146.0
2020-04-27 06:00:00	QQQ	ETF	216.82	216.82	216.21	216.25	74021.0
2020-04-27 07:00:00	QQQ	ETF	216.26	216.83	216.12	216.56	219884.0
2020-04-27 08:00:00	QQQ	ETF	216.61	217.0	215.78	216.44	212054.0
2020-04-27 09:00:00	QQQ	ETF	216.43	216.73	215.25	216.37	4478195.0
2020-04-27 10:00:00	QQQ	ETF	216.37	216.63	215.1062	215.2	4770198.0
2020-04-27 11:00:00	QQQ	ETF	215.17	216.33	214.95	215.86	4110646.0
2020-04-27 12:00:00	QQQ	ETF	215.87	216.06	215.1914	215.66	3448881.0
2020-04-27 13:00:00	QQQ	ETF	215.66	215.675	214.5	214.79	2906808.0
2020-04-27 14:00:00	QQQ	ETF	214.78	215.66	214.78	215.36	2453157.0
2020-04-27 15:00:00	QQQ	ETF	215.3651	215.97	215.13	215.35	5316879.0
2020-04-27 16:00:00	QQQ	ETF	215.36	215.56	215.17	215.3	810361.0
2020-04-27 17:00:00	QQQ	ETF	215.39	215.39	215.11	215.27	41404.0
2020-04-27 18:00:00	QQQ	ETF	215.24	215.31	214.88	215.09	56914.0
2020-04-27 19:00:00	QQQ	ETF	215.11	215.68	215.11	215.37	52472.0
2020-04-27 04:00:00	IWM	ETF	124.35	124.35	123.8	124.18	9329.0
2020-04-27 05:00:00	IWM	ETF	124.02	124.31	124.02	124.26	2201.0
2020-04-27 06:00:00	IWM	ETF	124.1	124.19	123.99	123.99	32766.0
2020-04-27 07:00:00	IWM	ETF	123.95	124.53	123.9	124.39	150067.0
2020-04-27 08:00:00	IWM	ETF	123.93	124.8	123.93	124.23	205250.0
2020-04-27 09:00:00	IWM	ETF	124.23	125.7	123.86	125.59	5243452.0
2020-04-27 10:00:00	IWM	ETF	125.6	126.29	125.12	125.9	4322557.0
2020-04-27 11:00:00	IWM	ETF	125.9	127.01	125.69	126.9	4274931.0
2020-04-27 12:00:00	IWM	ETF	126.89	127.82	126.66	127.73	4493561.0
2020-04-27 13:00:00	IWM	ETF	127.74	127.845	126.95	127.705	3708534.0
2020-04-27 14:00:00	IWM	ETF	127.7	128.18	127.4475	128.13	3002502.0
2020-04-27 15:00:00	IWM	ETF	128.13	128.44	127.28	127.39	6267936.0
2020-04-27 16:00:00	IWM	ETF	127.39	127.51	126.99	127.22	1235856.0
2020-04-27 17:00:00	IWM	ETF	127.4	127.4	127.2	127.36	606254.0
2020-04-27 18:00:00	IWM	ETF	127.36	127.36	126.96	127.14	26818.0
2020-04-27 19:00:00	IWM	ETF	127.34	127.49	127.27	127.27	53569.0
2020-04-27 04:00:00	DIA	ETF	239.2	239.7	238.56	239.5	600.0
2020-04-27 05:00:00	DIA	ETF	239.93	240.48	239.78	240.35	8723.0

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

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