PREVIEW / etf_1hour / 2020-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-27.parquet
  size:    391 KB
  rows:    13,335

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-03-27 04:00:00	SPY	ETF	257.11	258.39	256.47	256.52	366423.0
2020-03-27 05:00:00	SPY	ETF	256.59	257.51	255.4	255.48	366927.0
2020-03-27 06:00:00	SPY	ETF	255.44	257.14	254.33	254.36	515252.0
2020-03-27 07:00:00	SPY	ETF	254.57	256.28	253.44	253.68	1580620.0
2020-03-27 08:00:00	SPY	ETF	253.67	260.42	252.98	253.11	3055916.0
2020-03-27 09:00:00	SPY	ETF	253.06	254.98	251.05	253.17	26410232.0
2020-03-27 10:00:00	SPY	ETF	253.17	254.59	251.92	253.17	22966900.0
2020-03-27 11:00:00	SPY	ETF	253.22	256.225	252.2	252.68	22876345.0
2020-03-27 12:00:00	SPY	ETF	252.66	255.21	252.2	255.145	17399633.0
2020-03-27 13:00:00	SPY	ETF	255.14	257.3	253.6905	255.6699	20341517.0
2020-03-27 14:00:00	SPY	ETF	255.67	257.71	254.87	257.6	22309921.0
2020-03-27 15:00:00	SPY	ETF	257.62	260.81	252.55	253.39	60934020.0
2020-03-27 16:00:00	SPY	ETF	253.38	262.1279	252.03	252.34	20469732.0
2020-03-27 17:00:00	SPY	ETF	252.66	253.42	252.15	252.65	645913.0
2020-03-27 18:00:00	SPY	ETF	252.65	253.42	252.64	252.65	967201.0
2020-03-27 19:00:00	SPY	ETF	252.65	252.79	252.09	252.1	144246.0
2020-03-27 04:00:00	QQQ	ETF	188.53	189.28	187.97	188.42	87423.0
2020-03-27 05:00:00	QQQ	ETF	188.42	189.03	187.48	187.49	102019.0
2020-03-27 06:00:00	QQQ	ETF	187.45	188.66	186.92	187.04	103379.0
2020-03-27 07:00:00	QQQ	ETF	187.13	188.32	186.38	186.7	428376.0
2020-03-27 08:00:00	QQQ	ETF	186.6	190.6	186.19	186.71	686863.0
2020-03-27 09:00:00	QQQ	ETF	186.67	187.84	185.06	186.39	5962322.0
2020-03-27 10:00:00	QQQ	ETF	186.43	187.1	185.29	185.89	6174140.0
2020-03-27 11:00:00	QQQ	ETF	185.9178	187.99	185.63	185.675	5992983.0
2020-03-27 12:00:00	QQQ	ETF	185.68	186.96	185.18	186.89	4882002.0
2020-03-27 13:00:00	QQQ	ETF	186.89	188.51	186.19	187.59	4978344.0
2020-03-27 14:00:00	QQQ	ETF	187.595	188.9198	187.06	188.83	4732607.0
2020-03-27 15:00:00	QQQ	ETF	188.845	190.5149	184.66	184.94	12912537.0
2020-03-27 16:00:00	QQQ	ETF	184.95	185.49	184.47	184.6	1893142.0
2020-03-27 17:00:00	QQQ	ETF	184.49	185.3	184.49	184.95	184463.0
2020-03-27 18:00:00	QQQ	ETF	184.9	184.91	184.55	184.55	13735.0
2020-03-27 19:00:00	QQQ	ETF	184.55	184.85	184.25	184.25	29634.0
2020-03-27 04:00:00	IWM	ETF	114.08	114.59	113.82	114.0	16018.0
2020-03-27 05:00:00	IWM	ETF	113.76	114.26	113.24	113.3	42990.0
2020-03-27 06:00:00	IWM	ETF	113.0	113.7	112.76	112.76	67054.0
2020-03-27 07:00:00	IWM	ETF	112.74	113.57	112.08	112.1	293191.0
2020-03-27 08:00:00	IWM	ETF	113.0301	115.35	111.75	112.09	507465.0
2020-03-27 09:00:00	IWM	ETF	112.04	113.62	110.87	112.5	6384378.0
2020-03-27 10:00:00	IWM	ETF	112.5	113.16	111.57	112.5	4334360.0
2020-03-27 11:00:00	IWM	ETF	112.47	113.97	111.8	112.27	3158570.0
2020-03-27 12:00:00	IWM	ETF	112.25	113.82	111.92	113.56	2355039.0
2020-03-27 13:00:00	IWM	ETF	113.58	115.1782	113.0	114.21	3356174.0
2020-03-27 14:00:00	IWM	ETF	114.23	114.67	113.45	114.6	3113925.0
2020-03-27 15:00:00	IWM	ETF	114.605	116.02	112.12	112.56	8611344.0
2020-03-27 16:00:00	IWM	ETF	112.56	112.8	111.42	111.65	1437402.0
2020-03-27 17:00:00	IWM	ETF	111.62	112.56	111.61	111.62	101446.0
2020-03-27 18:00:00	IWM	ETF	111.71	111.9	111.61	111.62	12418.0
2020-03-27 19:00:00	IWM	ETF	111.75	111.8	111.51	111.53	7314.0
2020-03-27 04:00:00	DIA	ETF	222.5	222.61	221.18	221.18	15077.0
2020-03-27 05:00:00	DIA	ETF	221.02	221.32	220.0	220.0	14419.0

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

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