PREVIEW / etf_1hour / 2020-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-24.parquet
  size:    376 KB
  rows:    12,916

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-08-24 04:00:00	SPY	ETF	341.2	341.82	341.2	341.72	47128.0
2020-08-24 05:00:00	SPY	ETF	341.7	341.86	341.54	341.82	13352.0
2020-08-24 06:00:00	SPY	ETF	341.75	342.2	341.65	342.12	43613.0
2020-08-24 07:00:00	SPY	ETF	342.16	342.4	342.04	342.35	328793.0
2020-08-24 08:00:00	SPY	ETF	342.39	342.48	340.59	342.15	334326.0
2020-08-24 09:00:00	SPY	ETF	342.17	342.33	341.525	341.875	6275016.0
2020-08-24 10:00:00	SPY	ETF	341.88	342.41	341.06	341.31	8002923.0
2020-08-24 11:00:00	SPY	ETF	341.29	341.98	341.175	341.77	5092199.0
2020-08-24 12:00:00	SPY	ETF	341.78	342.07	341.6	341.691	2595070.0
2020-08-24 13:00:00	SPY	ETF	341.69	342.0564	341.5	341.77	2617655.0
2020-08-24 14:00:00	SPY	ETF	341.78	341.98	341.29	341.51	3598441.0
2020-08-24 15:00:00	SPY	ETF	341.51	343.0	341.14	342.94	10830941.0
2020-08-24 16:00:00	SPY	ETF	342.95	342.97	341.9286	342.73	7366035.0
2020-08-24 17:00:00	SPY	ETF	342.77	342.92	342.71	342.79	55629.0
2020-08-24 18:00:00	SPY	ETF	342.79	342.92	342.77	342.9	109532.0
2020-08-24 19:00:00	SPY	ETF	342.92	343.43	342.8	343.39	85074.0
2020-08-24 04:00:00	QQQ	ETF	284.08	284.84	284.08	284.74	57468.0
2020-08-24 05:00:00	QQQ	ETF	284.79	284.79	284.5	284.5	14468.0
2020-08-24 06:00:00	QQQ	ETF	284.57	284.72	284.34	284.58	90176.0
2020-08-24 07:00:00	QQQ	ETF	284.58	285.0	284.46	285.0	197588.0
2020-08-24 08:00:00	QQQ	ETF	285.1	285.33	283.4	285.13	381253.0
2020-08-24 09:00:00	QQQ	ETF	285.1	286.0	283.33	284.335	5751636.0
2020-08-24 10:00:00	QQQ	ETF	284.37	284.59	281.27	281.7	7752880.0
2020-08-24 11:00:00	QQQ	ETF	281.7	283.54	281.5	283.359	4157243.0
2020-08-24 12:00:00	QQQ	ETF	283.355	284.0	282.91	283.13	1908635.0
2020-08-24 13:00:00	QQQ	ETF	283.12	283.858	282.56	283.1	2175787.0
2020-08-24 14:00:00	QQQ	ETF	283.08	283.46	282.0	282.26	2698041.0
2020-08-24 15:00:00	QQQ	ETF	282.265	283.67	281.7099	283.61	4381298.0
2020-08-24 16:00:00	QQQ	ETF	283.615	284.0571	283.38	283.81	841552.0
2020-08-24 17:00:00	QQQ	ETF	283.81	283.85	283.63	283.77	12258.0
2020-08-24 18:00:00	QQQ	ETF	283.84	283.97	283.8	283.91	31395.0
2020-08-24 19:00:00	QQQ	ETF	283.93	284.19	283.76	284.11	65484.0
2020-08-24 04:00:00	IWM	ETF	155.37	155.89	155.21	155.87	30499.0
2020-08-24 05:00:00	IWM	ETF	155.76	155.88	155.76	155.8	4240.0
2020-08-24 06:00:00	IWM	ETF	155.75	155.96	155.72	155.96	62004.0
2020-08-24 07:00:00	IWM	ETF	155.96	156.16	155.9	156.14	60139.0
2020-08-24 08:00:00	IWM	ETF	156.0501	156.24	154.99	155.84	245918.0
2020-08-24 09:00:00	IWM	ETF	155.83	155.92	154.33	155.27	2381720.0
2020-08-24 10:00:00	IWM	ETF	155.28	156.2	155.235	155.69	2440018.0
2020-08-24 11:00:00	IWM	ETF	155.68	155.925	155.5	155.54	1154029.0
2020-08-24 12:00:00	IWM	ETF	155.53	155.74	155.45	155.45	806758.0
2020-08-24 13:00:00	IWM	ETF	155.455	155.68	155.37	155.6	761243.0
2020-08-24 14:00:00	IWM	ETF	155.605	155.62	155.29	155.545	735384.0
2020-08-24 15:00:00	IWM	ETF	155.53	156.27	155.4	156.24	2950084.0
2020-08-24 16:00:00	IWM	ETF	156.23	156.3	154.2529	156.23	698845.0
2020-08-24 17:00:00	IWM	ETF	156.25	156.25	156.17	156.18	1620.0
2020-08-24 18:00:00	IWM	ETF	156.23	156.3	156.2	156.3	21537.0
2020-08-24 19:00:00	IWM	ETF	156.31	156.67	156.27	156.59	27793.0
2020-08-24 04:00:00	DIA	ETF	280.38	280.95	280.38	280.86	3285.0
2020-08-24 05:00:00	DIA	ETF	281.34	281.48	281.34	281.48	375.0

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

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