PREVIEW / etf_1hour / 2019-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-27.parquet
  size:    336 KB
  rows:    11,076

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
2019-11-27 04:00:00	SPY	ETF	314.89	315.09	314.85	315.02	12045.0
2019-11-27 05:00:00	SPY	ETF	315.05	315.13	315.0	315.05	14756.0
2019-11-27 06:00:00	SPY	ETF	315.05	315.05	314.78	314.78	21178.0
2019-11-27 07:00:00	SPY	ETF	314.78	314.9	314.75	314.88	68559.0
2019-11-27 08:00:00	SPY	ETF	314.8	315.03	314.63	314.68	302425.0
2019-11-27 09:00:00	SPY	ETF	314.7	314.76	314.37	314.61	3422338.0
2019-11-27 10:00:00	SPY	ETF	314.62	314.759	314.37	314.68	6761705.0
2019-11-27 11:00:00	SPY	ETF	314.68	314.89	314.5	314.85	7131284.0
2019-11-27 12:00:00	SPY	ETF	314.855	315.01	314.84	314.935	2472443.0
2019-11-27 13:00:00	SPY	ETF	314.94	315.42	314.9	315.295	4550940.0
2019-11-27 14:00:00	SPY	ETF	315.2905	315.44	315.21	315.335	2744461.0
2019-11-27 15:00:00	SPY	ETF	315.335	315.47	315.23	315.44	8184436.0
2019-11-27 16:00:00	SPY	ETF	315.43	315.57	314.0743	315.5	5463876.0
2019-11-27 17:00:00	SPY	ETF	315.5	315.6	315.47	315.52	358875.0
2019-11-27 18:00:00	SPY	ETF	315.57	315.57	314.41	314.55	399539.0
2019-11-27 19:00:00	SPY	ETF	314.59	314.75	314.36	314.52	124305.0
2019-11-27 04:00:00	QQQ	ETF	205.26	205.48	205.26	205.47	7926.0
2019-11-27 05:00:00	QQQ	ETF	205.49	205.49	205.42	205.46	2150.0
2019-11-27 06:00:00	QQQ	ETF	205.43	205.43	205.28	205.28	8511.0
2019-11-27 07:00:00	QQQ	ETF	205.28	205.35	205.22	205.27	44123.0
2019-11-27 08:00:00	QQQ	ETF	205.29	205.42	205.16	205.16	82137.0
2019-11-27 09:00:00	QQQ	ETF	205.15	205.27	204.89	205.23	2009942.0
2019-11-27 10:00:00	QQQ	ETF	205.23	205.56	205.09	205.5104	1615495.0
2019-11-27 11:00:00	QQQ	ETF	205.53	205.73	205.46	205.725	1502293.0
2019-11-27 12:00:00	QQQ	ETF	205.72	205.86	205.69	205.725	1162458.0
2019-11-27 13:00:00	QQQ	ETF	205.72	205.97	205.71	205.82	1499716.0
2019-11-27 14:00:00	QQQ	ETF	205.8271	205.92	205.78	205.84	955625.0
2019-11-27 15:00:00	QQQ	ETF	205.84	206.05	205.774	206.05	3491734.0
2019-11-27 16:00:00	QQQ	ETF	206.04	206.25	205.99	206.22	1361064.0
2019-11-27 17:00:00	QQQ	ETF	206.2	206.25	206.16	206.25	10499.0
2019-11-27 18:00:00	QQQ	ETF	206.16	206.16	205.37	205.48	77111.0
2019-11-27 19:00:00	QQQ	ETF	205.48	205.54	205.3	205.41	38934.0
2019-11-27 04:00:00	IWM	ETF	162.09	162.35	162.09	162.3	700.0
2019-11-27 05:00:00	IWM	ETF	162.33	162.33	162.33	162.33	4650.0
2019-11-27 06:00:00	IWM	ETF	162.35	162.35	162.1	162.1	12104.0
2019-11-27 07:00:00	IWM	ETF	162.1	162.2	162.06	162.2	24810.0
2019-11-27 08:00:00	IWM	ETF	162.12	162.4199	161.97	162.26	51943.0
2019-11-27 09:00:00	IWM	ETF	162.2499	162.78	162.08	162.63	1452600.0
2019-11-27 10:00:00	IWM	ETF	162.64	162.67	162.15	162.54	1836217.0
2019-11-27 11:00:00	IWM	ETF	162.54	162.58	162.215	162.41	738423.0
2019-11-27 12:00:00	IWM	ETF	162.41	162.7	162.405	162.45	857956.0
2019-11-27 13:00:00	IWM	ETF	162.46	162.93	162.435	162.805	1529299.0
2019-11-27 14:00:00	IWM	ETF	162.8	162.9	162.6767	162.76	537592.0
2019-11-27 15:00:00	IWM	ETF	162.76	162.84	162.595	162.8	2445430.0
2019-11-27 16:00:00	IWM	ETF	162.79	162.9	162.71	162.89	842226.0
2019-11-27 17:00:00	IWM	ETF	162.84	162.9	162.84	162.9	1284.0
2019-11-27 18:00:00	IWM	ETF	162.85	162.85	162.26	162.33	22756.0
2019-11-27 19:00:00	IWM	ETF	162.37	162.38	162.21	162.33	7942.0
2019-11-27 07:00:00	DIA	ETF	281.77	281.78	281.7	281.7	3463.0
2019-11-27 08:00:00	DIA	ETF	281.7001	281.8	281.62	281.77	7517.0

> showing 50 of 11,076 rows — these rows as CSV

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