PREVIEW / etf_1hour / 2020-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-19.parquet
  size:    386 KB
  rows:    13,108

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-11-19 04:00:00	SPY	ETF	354.84	355.47	354.42	354.8	55522.0
2020-11-19 05:00:00	SPY	ETF	354.8	355.41	354.21	355.24	34180.0
2020-11-19 06:00:00	SPY	ETF	355.19	356.0	354.74	355.82	58277.0
2020-11-19 07:00:00	SPY	ETF	355.92	356.33	355.88	356.03	263920.0
2020-11-19 08:00:00	SPY	ETF	355.8801	357.0	354.8104	355.94	417083.0
2020-11-19 09:00:00	SPY	ETF	355.98	356.36	354.15	356.115	7415535.0
2020-11-19 10:00:00	SPY	ETF	356.12	356.71	354.79	355.93	8883085.0
2020-11-19 11:00:00	SPY	ETF	355.92	356.3	355.353	355.9219	8971766.0
2020-11-19 12:00:00	SPY	ETF	355.93	356.24	355.1911	355.5	4044371.0
2020-11-19 13:00:00	SPY	ETF	355.51	356.67	355.42	356.53	4758912.0
2020-11-19 14:00:00	SPY	ETF	356.53	358.13	356.39	357.68	6110904.0
2020-11-19 15:00:00	SPY	ETF	357.67	358.18	357.13	357.745	10573746.0
2020-11-19 16:00:00	SPY	ETF	357.75	358.07	356.08	356.18	6236691.0
2020-11-19 17:00:00	SPY	ETF	356.34	357.78	355.87	356.3	249975.0
2020-11-19 18:00:00	SPY	ETF	356.26	356.26	354.43	354.86	742115.0
2020-11-19 19:00:00	SPY	ETF	354.9	355.9	354.88	355.24	492344.0
2020-11-19 04:00:00	QQQ	ETF	288.14	288.94	287.99	288.69	43414.0
2020-11-19 05:00:00	QQQ	ETF	288.77	289.14	288.34	289.0	19397.0
2020-11-19 06:00:00	QQQ	ETF	289.03	289.51	288.52	289.33	44094.0
2020-11-19 07:00:00	QQQ	ETF	289.5	289.93	289.38	289.79	161341.0
2020-11-19 08:00:00	QQQ	ETF	289.5102	290.17	288.69	289.71	174819.0
2020-11-19 09:00:00	QQQ	ETF	289.71	290.88	288.85	290.75	3185915.0
2020-11-19 10:00:00	QQQ	ETF	290.79	291.57	289.87	291.12	3364500.0
2020-11-19 11:00:00	QQQ	ETF	291.12	291.77	290.71	291.35	1733127.0
2020-11-19 12:00:00	QQQ	ETF	291.35	291.81	290.54	290.782	1952524.0
2020-11-19 13:00:00	QQQ	ETF	290.8	291.89	290.68	291.77	1375847.0
2020-11-19 14:00:00	QQQ	ETF	291.8	292.56	291.41	292.515	1918517.0
2020-11-19 15:00:00	QQQ	ETF	292.52	292.7	291.92	292.24	3442404.0
2020-11-19 16:00:00	QQQ	ETF	292.23	292.56	291.67	291.87	1764236.0
2020-11-19 17:00:00	QQQ	ETF	291.75	292.0	291.75	291.99	71326.0
2020-11-19 18:00:00	QQQ	ETF	291.8	291.99	290.87	291.22	303706.0
2020-11-19 19:00:00	QQQ	ETF	291.25	291.8	291.22	291.47	132593.0
2020-11-19 04:00:00	IWM	ETF	175.09	175.49	174.68	175.19	19282.0
2020-11-19 05:00:00	IWM	ETF	175.05	175.22	174.65	175.22	12592.0
2020-11-19 06:00:00	IWM	ETF	175.2	175.49	174.8	175.46	75050.0
2020-11-19 07:00:00	IWM	ETF	175.41	175.75	175.41	175.51	100198.0
2020-11-19 08:00:00	IWM	ETF	175.5	176.01	175.27	175.9	221364.0
2020-11-19 09:00:00	IWM	ETF	175.99	176.745	175.07	176.48	2589856.0
2020-11-19 10:00:00	IWM	ETF	176.48	176.79	175.64	176.12	3173326.0
2020-11-19 11:00:00	IWM	ETF	176.12	176.35	175.61	175.96	1434241.0
2020-11-19 12:00:00	IWM	ETF	175.975	176.03	175.35	175.73	1668297.0
2020-11-19 13:00:00	IWM	ETF	175.73	176.42	175.68	176.26	1068259.0
2020-11-19 14:00:00	IWM	ETF	176.27	177.36	176.15	176.84	1416179.0
2020-11-19 15:00:00	IWM	ETF	176.84	177.59	176.625	177.3	3902776.0
2020-11-19 16:00:00	IWM	ETF	177.31	177.53	175.94	176.0	897901.0
2020-11-19 17:00:00	IWM	ETF	176.12	177.31	175.9183	176.35	168974.0
2020-11-19 18:00:00	IWM	ETF	176.25	177.31	174.95	175.35	206767.0
2020-11-19 19:00:00	IWM	ETF	175.38	175.98	175.33	175.63	58436.0
2020-11-19 04:00:00	DIA	ETF	293.64	293.86	293.22	293.84	5322.0
2020-11-19 05:00:00	DIA	ETF	293.28	293.92	293.17	293.87	1540.0

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

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