PREVIEW / etf_1hour / 2019-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-27.parquet
  size:    344 KB
  rows:    11,474

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-12-27 04:00:00	SPY	ETF	323.61	323.67	323.53	323.58	5256.0
2019-12-27 05:00:00	SPY	ETF	323.72	324.03	323.72	323.95	7206.0
2019-12-27 06:00:00	SPY	ETF	323.94	324.03	323.84	323.95	12232.0
2019-12-27 07:00:00	SPY	ETF	323.95	324.0	323.86	323.86	34462.0
2019-12-27 08:00:00	SPY	ETF	323.88	324.06	322.94	323.74	262405.0
2019-12-27 09:00:00	SPY	ETF	323.75	323.84	322.51	322.55	4381329.0
2019-12-27 10:00:00	SPY	ETF	322.55	323.26	322.485	323.205	5327145.0
2019-12-27 11:00:00	SPY	ETF	323.22	323.48	323.2005	323.28	5830537.0
2019-12-27 12:00:00	SPY	ETF	323.28	323.37	323.03	323.25	2406480.0
2019-12-27 13:00:00	SPY	ETF	323.25	323.2961	322.85	322.91	3628337.0
2019-12-27 14:00:00	SPY	ETF	322.92	323.3	322.91	323.247	4146498.0
2019-12-27 15:00:00	SPY	ETF	323.24	323.25	322.28	322.86	9530236.0
2019-12-27 16:00:00	SPY	ETF	322.84	322.8944	322.35	322.42	5845802.0
2019-12-27 17:00:00	SPY	ETF	322.41	322.54	322.41	322.53	11766.0
2019-12-27 18:00:00	SPY	ETF	322.5	322.5	322.44	322.45	12358.0
2019-12-27 19:00:00	SPY	ETF	322.44	322.49	322.29	322.39	16876.0
2019-12-27 04:00:00	QQQ	ETF	214.42	214.46	214.34	214.38	23309.0
2019-12-27 05:00:00	QQQ	ETF	214.4	214.66	214.37	214.66	23832.0
2019-12-27 06:00:00	QQQ	ETF	214.76	214.76	214.59	214.67	21195.0
2019-12-27 07:00:00	QQQ	ETF	214.67	214.78	214.59	214.67	66895.0
2019-12-27 08:00:00	QQQ	ETF	214.65	214.79	213.79	214.6	122562.0
2019-12-27 09:00:00	QQQ	ETF	214.6	214.67	213.295	213.32	2920507.0
2019-12-27 10:00:00	QQQ	ETF	213.32	214.09	213.2847	214.0	2023346.0
2019-12-27 11:00:00	QQQ	ETF	214.01	214.26	214.01	214.01	1136810.0
2019-12-27 12:00:00	QQQ	ETF	214.0065	214.11	213.69	213.91	1216898.0
2019-12-27 13:00:00	QQQ	ETF	213.905	213.95	213.47	213.64	1557859.0
2019-12-27 14:00:00	QQQ	ETF	213.65	213.97	213.6	213.95	1102575.0
2019-12-27 15:00:00	QQQ	ETF	213.94	213.94	213.04	213.6	4360026.0
2019-12-27 16:00:00	QQQ	ETF	213.6	213.63	213.25	213.28	1339172.0
2019-12-27 17:00:00	QQQ	ETF	213.37	213.49	213.32	213.44	32627.0
2019-12-27 18:00:00	QQQ	ETF	213.35	213.37	213.32	213.37	1775.0
2019-12-27 19:00:00	QQQ	ETF	213.32	213.4	213.23	213.23	4867.0
2019-12-27 05:00:00	IWM	ETF	167.1	167.1	167.1	167.1	500.0
2019-12-27 06:00:00	IWM	ETF	167.2	167.2	167.05	167.05	6161.0
2019-12-27 07:00:00	IWM	ETF	167.17	167.23	167.14	167.15	13331.0
2019-12-27 08:00:00	IWM	ETF	167.15	167.29	167.01	167.01	42115.0
2019-12-27 09:00:00	IWM	ETF	167.0	167.12	165.64	165.65	1499048.0
2019-12-27 10:00:00	IWM	ETF	165.65	166.19	165.6	166.165	1812034.0
2019-12-27 11:00:00	IWM	ETF	166.165	166.42	166.112	166.33	964382.0
2019-12-27 12:00:00	IWM	ETF	166.32	166.37	165.8794	166.02	1373350.0
2019-12-27 13:00:00	IWM	ETF	166.02	166.13	165.91	166.01	554434.0
2019-12-27 14:00:00	IWM	ETF	166.0041	166.065	165.95	166.03	453871.0
2019-12-27 15:00:00	IWM	ETF	166.04	166.075	165.43	165.83	2454599.0
2019-12-27 16:00:00	IWM	ETF	165.86	165.89	165.52	165.52	1442686.0
2019-12-27 17:00:00	IWM	ETF	165.53	165.63	165.53	165.6	3395.0
2019-12-27 18:00:00	IWM	ETF	165.61	165.61	165.61	165.61	730.0
2019-12-27 19:00:00	IWM	ETF	165.6	165.6	165.6	165.6	2603.0
2019-12-27 04:00:00	DIA	ETF	286.79	286.79	286.79	286.79	231.0
2019-12-27 06:00:00	DIA	ETF	287.13	287.13	287.13	287.13	500.0
2019-12-27 07:00:00	DIA	ETF	287.1	287.1	287.05	287.05	400.0

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

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