PREVIEW / etf_1hour / 2020-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-15.parquet
  size:    352 KB
  rows:    12,070

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-15 04:00:00	SPY	ETF	286.34	286.45	285.58	285.78	25786.0
2020-05-15 05:00:00	SPY	ETF	285.98	286.15	285.2	285.28	33048.0
2020-05-15 06:00:00	SPY	ETF	285.4	285.75	283.17	283.17	267867.0
2020-05-15 07:00:00	SPY	ETF	283.32	283.37	281.66	281.91	1140982.0
2020-05-15 08:00:00	SPY	ETF	282.4999	286.24	281.45	282.36	1409461.0
2020-05-15 09:00:00	SPY	ETF	282.4	284.22	281.34	283.845	12077256.0
2020-05-15 10:00:00	SPY	ETF	283.85	285.08	282.58	282.91	17055042.0
2020-05-15 11:00:00	SPY	ETF	282.91	283.31	281.89	283.14	11403627.0
2020-05-15 12:00:00	SPY	ETF	283.14	284.78	282.9602	284.13	10247463.0
2020-05-15 13:00:00	SPY	ETF	284.125	285.14	284.055	285.0	7870415.0
2020-05-15 14:00:00	SPY	ETF	284.99	285.96	284.48	284.61	10843626.0
2020-05-15 15:00:00	SPY	ETF	284.62	286.33	284.37	286.26	22569791.0
2020-05-15 16:00:00	SPY	ETF	286.25	286.31	284.95	285.79	11834719.0
2020-05-15 17:00:00	SPY	ETF	285.74	286.28	285.04	285.73	2920033.0
2020-05-15 18:00:00	SPY	ETF	285.75	285.84	285.58	285.76	57100.0
2020-05-15 19:00:00	SPY	ETF	285.79	285.85	285.61	285.7	66001.0
2020-05-15 04:00:00	QQQ	ETF	222.97	223.04	222.48	222.73	18054.0
2020-05-15 05:00:00	QQQ	ETF	222.9	222.98	222.24	222.3	40421.0
2020-05-15 06:00:00	QQQ	ETF	222.37	222.72	220.52	220.58	187445.0
2020-05-15 07:00:00	QQQ	ETF	220.65	220.65	218.41	218.54	1107037.0
2020-05-15 08:00:00	QQQ	ETF	219.1101	222.85	217.98	218.56	588838.0
2020-05-15 09:00:00	QQQ	ETF	218.63	220.16	217.91	220.1002	6523420.0
2020-05-15 10:00:00	QQQ	ETF	220.1	221.1	218.9	219.0968	7385418.0
2020-05-15 11:00:00	QQQ	ETF	219.08	219.66	218.4	219.575	4847619.0
2020-05-15 12:00:00	QQQ	ETF	219.565	221.315	219.4401	221.14	4974782.0
2020-05-15 13:00:00	QQQ	ETF	221.14	222.26	220.8805	221.6699	4819312.0
2020-05-15 14:00:00	QQQ	ETF	221.66	222.48	221.31	221.565	4374020.0
2020-05-15 15:00:00	QQQ	ETF	221.58	223.33	221.38	223.28	7131853.0
2020-05-15 16:00:00	QQQ	ETF	223.26	223.3	221.1725	222.57	1874944.0
2020-05-15 17:00:00	QQQ	ETF	222.61	223.27	222.46	222.71	65399.0
2020-05-15 18:00:00	QQQ	ETF	222.72	222.83	222.56	222.77	65723.0
2020-05-15 19:00:00	QQQ	ETF	222.75	222.85	222.71	222.75	31473.0
2020-05-15 04:00:00	IWM	ETF	123.77	123.91	123.6	123.85	7400.0
2020-05-15 05:00:00	IWM	ETF	123.95	124.13	123.46	123.48	7422.0
2020-05-15 06:00:00	IWM	ETF	123.56	123.58	122.14	122.14	33700.0
2020-05-15 07:00:00	IWM	ETF	122.16	122.3	121.25	121.41	183950.0
2020-05-15 08:00:00	IWM	ETF	121.8401	123.33	121.0	121.8604	358123.0
2020-05-15 09:00:00	IWM	ETF	121.89	123.62	121.46	123.2	5241751.0
2020-05-15 10:00:00	IWM	ETF	123.19	124.47	123.02	123.71	6662190.0
2020-05-15 11:00:00	IWM	ETF	123.7	124.54	123.15	124.1	4352959.0
2020-05-15 12:00:00	IWM	ETF	124.08	124.975	123.95	124.4599	3610322.0
2020-05-15 13:00:00	IWM	ETF	124.47	125.2	124.33	125.0	2963426.0
2020-05-15 14:00:00	IWM	ETF	125.01	125.53	124.52	124.61	2804273.0
2020-05-15 15:00:00	IWM	ETF	124.64	125.22	124.54	125.13	6295354.0
2020-05-15 16:00:00	IWM	ETF	125.13	125.14	124.06	124.87	1424639.0
2020-05-15 17:00:00	IWM	ETF	124.88	125.08	124.6	125.08	315842.0
2020-05-15 18:00:00	IWM	ETF	124.6	124.75	124.59	124.75	3750.0
2020-05-15 19:00:00	IWM	ETF	124.75	124.75	124.5	124.56	2504.0
2020-05-15 04:00:00	DIA	ETF	237.1	237.72	237.02	237.02	1200.0
2020-05-15 05:00:00	DIA	ETF	237.0	237.0	236.52	236.52	300.0

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

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