PREVIEW / etf_1hour / 2020-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-19.parquet
  size:    402 KB
  rows:    13,644

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-19 04:00:00	SPY	ETF	240.23	243.17	236.01	242.39	413097.0
2020-03-19 05:00:00	SPY	ETF	242.15	242.89	238.56	239.35	182063.0
2020-03-19 06:00:00	SPY	ETF	239.23	239.23	236.76	237.6	324184.0
2020-03-19 07:00:00	SPY	ETF	238.0	239.56	235.03	235.6	1157505.0
2020-03-19 08:00:00	SPY	ETF	239.2999	241.02	229.31	238.33	2247149.0
2020-03-19 09:00:00	SPY	ETF	238.4	240.0	232.22	237.98	32686421.0
2020-03-19 10:00:00	SPY	ETF	237.99	243.91	236.54	239.275	46042189.0
2020-03-19 11:00:00	SPY	ETF	239.22	246.37	238.62	242.73	40315277.0
2020-03-19 12:00:00	SPY	ETF	242.7	243.9	238.82	242.25	28783809.0
2020-03-19 13:00:00	SPY	ETF	242.2	246.24	241.06	244.47	26451002.0
2020-03-19 14:00:00	SPY	ETF	244.48	247.38	242.37	244.43	26353123.0
2020-03-19 15:00:00	SPY	ETF	244.44	245.62	240.33	241.16	62022621.0
2020-03-19 16:00:00	SPY	ETF	241.16	241.4789	236.5	237.13	13804254.0
2020-03-19 17:00:00	SPY	ETF	237.02	241.4576	236.4	237.05	4545153.0
2020-03-19 18:00:00	SPY	ETF	236.86	238.33	235.11	235.4	790759.0
2020-03-19 19:00:00	SPY	ETF	235.53	237.5	234.95	237.18	398490.0
2020-03-19 04:00:00	QQQ	ETF	174.5	179.37	174.36	178.78	168303.0
2020-03-19 05:00:00	QQQ	ETF	178.63	179.11	175.92	175.97	186944.0
2020-03-19 06:00:00	QQQ	ETF	175.88	175.95	174.36	174.92	148173.0
2020-03-19 07:00:00	QQQ	ETF	175.25	176.44	173.1	173.61	355461.0
2020-03-19 08:00:00	QQQ	ETF	176.2098	177.38	168.92	175.29	727604.0
2020-03-19 09:00:00	QQQ	ETF	175.27	177.0599	171.63	176.88	9970543.0
2020-03-19 10:00:00	QQQ	ETF	176.89	180.84	175.84	177.09	20359427.0
2020-03-19 11:00:00	QQQ	ETF	177.09	182.29	176.66	179.1698	16206848.0
2020-03-19 12:00:00	QQQ	ETF	179.15	180.96	177.07	179.67	11407146.0
2020-03-19 13:00:00	QQQ	ETF	179.64	182.44	178.99	181.34	9373976.0
2020-03-19 14:00:00	QQQ	ETF	181.37	183.49	179.43	181.59	9373502.0
2020-03-19 15:00:00	QQQ	ETF	181.58	182.41	177.42	177.74	19424488.0
2020-03-19 16:00:00	QQQ	ETF	177.74	178.28	175.09	175.81	2818356.0
2020-03-19 17:00:00	QQQ	ETF	175.84	177.91	175.4	175.77	1118658.0
2020-03-19 18:00:00	QQQ	ETF	175.75	176.56	174.6	174.89	351978.0
2020-03-19 19:00:00	QQQ	ETF	174.94	176.25	174.5	176.15	452253.0
2020-03-19 04:00:00	IWM	ETF	99.13	101.0	98.8	101.0	34000.0
2020-03-19 05:00:00	IWM	ETF	100.49	101.01	99.64	100.15	19992.0
2020-03-19 06:00:00	IWM	ETF	99.39	99.74	98.9	99.29	10954.0
2020-03-19 07:00:00	IWM	ETF	99.35	100.0	98.06	98.16	97285.0
2020-03-19 08:00:00	IWM	ETF	99.05	100.06	96.98	99.78	241212.0
2020-03-19 09:00:00	IWM	ETF	99.91	100.3	95.69	100.13	4486299.0
2020-03-19 10:00:00	IWM	ETF	100.14	104.06	99.56	101.17	8049419.0
2020-03-19 11:00:00	IWM	ETF	101.17	104.63	100.79	102.57	6003407.0
2020-03-19 12:00:00	IWM	ETF	102.59	103.69	100.25	102.899	6180573.0
2020-03-19 13:00:00	IWM	ETF	102.91	105.16	102.345	103.85	5420592.0
2020-03-19 14:00:00	IWM	ETF	103.85	106.47	103.4	105.59	7375616.0
2020-03-19 15:00:00	IWM	ETF	105.57	106.8	103.86	103.86	11230544.0
2020-03-19 16:00:00	IWM	ETF	103.87	104.72	102.41	103.0	3657211.0
2020-03-19 17:00:00	IWM	ETF	103.7	103.87	102.4	102.64	65862.0
2020-03-19 18:00:00	IWM	ETF	102.64	103.87	100.88	100.88	154173.0
2020-03-19 19:00:00	IWM	ETF	100.94	102.28	100.61	102.28	19994.0
2020-03-19 04:00:00	DIA	ETF	197.41	201.8	197.41	200.33	29386.0
2020-03-19 05:00:00	DIA	ETF	200.8	200.91	197.75	198.14	30768.0

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

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