PREVIEW / etf_1hour / 2020-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-24.parquet
  size:    398 KB
  rows:    13,661

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-24 04:00:00	SPY	ETF	232.03	233.5	231.05	232.74	189145.0
2020-03-24 05:00:00	SPY	ETF	232.68	234.47	232.29	234.12	181206.0
2020-03-24 06:00:00	SPY	ETF	234.11	235.2	234.01	234.89	273779.0
2020-03-24 07:00:00	SPY	ETF	234.89	234.98	231.77	232.79	1585470.0
2020-03-24 08:00:00	SPY	ETF	232.79	235.09	228.03	233.59	2563812.0
2020-03-24 09:00:00	SPY	ETF	233.59	238.5	232.56	235.51	29470572.0
2020-03-24 10:00:00	SPY	ETF	235.4994	239.36	234.6	237.46	30588651.0
2020-03-24 11:00:00	SPY	ETF	237.48	240.46	236.16	240.43	24012281.0
2020-03-24 12:00:00	SPY	ETF	240.43	242.96	239.57	239.65	27106028.0
2020-03-24 13:00:00	SPY	ETF	239.66	240.65	236.76	237.25	26777417.0
2020-03-24 14:00:00	SPY	ETF	237.24	240.67	235.05	240.58	28368030.0
2020-03-24 15:00:00	SPY	ETF	240.56	244.1	240.21	243.59	46801479.0
2020-03-24 16:00:00	SPY	ETF	243.59	245.02	240.3109	244.45	11282787.0
2020-03-24 17:00:00	SPY	ETF	244.42	244.74	243.01	244.2	1493434.0
2020-03-24 18:00:00	SPY	ETF	244.26	247.17	243.03	245.75	1506313.0
2020-03-24 19:00:00	SPY	ETF	245.75	245.84	241.56	242.47	931486.0
2020-03-24 04:00:00	QQQ	ETF	177.48	178.6	176.9	178.18	223082.0
2020-03-24 05:00:00	QQQ	ETF	178.2	179.48	177.91	179.45	105397.0
2020-03-24 06:00:00	QQQ	ETF	179.48	180.12	179.42	179.8	121995.0
2020-03-24 07:00:00	QQQ	ETF	179.82	179.89	177.02	177.72	494884.0
2020-03-24 08:00:00	QQQ	ETF	177.43	180.11	174.6	178.85	1114340.0
2020-03-24 09:00:00	QQQ	ETF	179.0	181.31	178.37	178.95	10532050.0
2020-03-24 10:00:00	QQQ	ETF	178.93	181.96	178.36	180.07	11438586.0
2020-03-24 11:00:00	QQQ	ETF	180.12	182.12	179.1608	181.8516	6945026.0
2020-03-24 12:00:00	QQQ	ETF	181.86	183.64	181.28	181.34	8126062.0
2020-03-24 13:00:00	QQQ	ETF	181.35	181.93	179.1	179.35	9438946.0
2020-03-24 14:00:00	QQQ	ETF	179.38	182.19	177.95	182.13	9130665.0
2020-03-24 15:00:00	QQQ	ETF	182.13	183.83	181.7107	183.79	15621093.0
2020-03-24 16:00:00	QQQ	ETF	183.82	184.64	182.53	184.16	2179816.0
2020-03-24 17:00:00	QQQ	ETF	184.17	184.28	183.33	183.85	72820.0
2020-03-24 18:00:00	QQQ	ETF	183.9	186.09	183.25	184.93	252025.0
2020-03-24 19:00:00	QQQ	ETF	184.88	184.91	182.22	182.85	163050.0
2020-03-24 04:00:00	IWM	ETF	105.0	105.53	104.1	104.4	28930.0
2020-03-24 05:00:00	IWM	ETF	104.39	105.5	104.27	105.5	19170.0
2020-03-24 06:00:00	IWM	ETF	105.44	106.0	105.44	105.62	13905.0
2020-03-24 07:00:00	IWM	ETF	105.66	105.9	104.1	104.17	101002.0
2020-03-24 08:00:00	IWM	ETF	104.23	105.51	103.0	104.56	347130.0
2020-03-24 09:00:00	IWM	ETF	104.58	108.25	104.0	105.71	7929479.0
2020-03-24 10:00:00	IWM	ETF	105.74	107.63	105.1	106.13	7793385.0
2020-03-24 11:00:00	IWM	ETF	106.15	107.82	105.39	107.805	5310582.0
2020-03-24 12:00:00	IWM	ETF	107.79	108.52	106.2	106.33	6322144.0
2020-03-24 13:00:00	IWM	ETF	106.34	107.24	105.12	105.66	5314890.0
2020-03-24 14:00:00	IWM	ETF	105.62	107.91	104.25	107.89	6596681.0
2020-03-24 15:00:00	IWM	ETF	107.88	109.33	107.08	109.17	11444638.0
2020-03-24 16:00:00	IWM	ETF	109.19	110.42	108.52	109.97	4329357.0
2020-03-24 17:00:00	IWM	ETF	109.66	109.66	109.0	109.11	137001.0
2020-03-24 18:00:00	IWM	ETF	109.5	110.89	109.04	110.55	160827.0
2020-03-24 19:00:00	IWM	ETF	110.43	110.43	108.35	108.67	128196.0
2020-03-24 04:00:00	DIA	ETF	194.1	195.0	193.12	194.0	18022.0
2020-03-24 05:00:00	DIA	ETF	194.41	195.5	194.23	195.5	12998.0

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

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