PREVIEW / etf_1hour / 2019-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-23.parquet
  size:    338 KB
  rows:    11,097

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-05-23 04:00:00	SPY	ETF	284.2	284.2	283.4	283.7	27328.0
2019-05-23 05:00:00	SPY	ETF	283.6	283.71	282.77	282.9	43333.0
2019-05-23 06:00:00	SPY	ETF	282.85	283.2	282.6	282.95	135649.0
2019-05-23 07:00:00	SPY	ETF	283.08	283.6	283.03	283.34	351441.0
2019-05-23 08:00:00	SPY	ETF	283.26	285.63	282.99	283.24	840705.0
2019-05-23 09:00:00	SPY	ETF	283.29	283.3	281.69	282.02	10089442.0
2019-05-23 10:00:00	SPY	ETF	282.02	282.88	281.53	282.635	12433092.0
2019-05-23 11:00:00	SPY	ETF	282.64	282.67	281.24	281.29	8578306.0
2019-05-23 12:00:00	SPY	ETF	281.3	281.92	280.86	280.93	9183087.0
2019-05-23 13:00:00	SPY	ETF	280.92	281.54	280.72	281.21	8167972.0
2019-05-23 14:00:00	SPY	ETF	281.2	281.43	280.63	280.9	9796360.0
2019-05-23 15:00:00	SPY	ETF	280.8991	282.39	280.57	282.27	24663289.0
2019-05-23 16:00:00	SPY	ETF	282.25	282.5	281.89	282.08	12554595.0
2019-05-23 17:00:00	SPY	ETF	282.06	282.2	282.06	282.13	118124.0
2019-05-23 18:00:00	SPY	ETF	282.15	282.47	281.97	282.05	183600.0
2019-05-23 19:00:00	SPY	ETF	282.09	282.43	282.03	282.3	42553.0
2019-05-23 04:00:00	QQQ	ETF	179.69	179.69	178.9	179.08	43024.0
2019-05-23 05:00:00	QQQ	ETF	179.05	179.2	178.53	178.53	87899.0
2019-05-23 06:00:00	QQQ	ETF	178.55	178.92	178.33	178.62	79207.0
2019-05-23 07:00:00	QQQ	ETF	178.69	179.14	178.69	179.0	191074.0
2019-05-23 08:00:00	QQQ	ETF	179.04	181.02	178.68	179.03	347881.0
2019-05-23 09:00:00	QQQ	ETF	179.04	179.08	178.105	178.45	5568129.0
2019-05-23 10:00:00	QQQ	ETF	178.445	178.99	177.95	178.7175	5588582.0
2019-05-23 11:00:00	QQQ	ETF	178.7149	178.76	177.7	177.74	4412157.0
2019-05-23 12:00:00	QQQ	ETF	177.74	178.06	177.19	177.27	4603701.0
2019-05-23 13:00:00	QQQ	ETF	177.25	177.89	177.14	177.5466	3316514.0
2019-05-23 14:00:00	QQQ	ETF	177.55	177.71	177.19	177.5	3488020.0
2019-05-23 15:00:00	QQQ	ETF	177.49	178.58	177.22	178.29	11440527.0
2019-05-23 16:00:00	QQQ	ETF	178.29	178.57	178.12	178.28	1453816.0
2019-05-23 17:00:00	QQQ	ETF	178.21	178.35	178.14	178.25	12065.0
2019-05-23 18:00:00	QQQ	ETF	178.29	178.56	178.11	178.17	233855.0
2019-05-23 19:00:00	QQQ	ETF	178.24	178.52	178.2	178.47	58070.0
2019-05-23 04:00:00	IWM	ETF	151.82	151.82	151.14	151.26	12560.0
2019-05-23 05:00:00	IWM	ETF	151.25	151.25	150.86	150.95	7000.0
2019-05-23 06:00:00	IWM	ETF	150.75	151.05	150.75	150.97	10298.0
2019-05-23 07:00:00	IWM	ETF	151.09	151.3	151.09	151.15	63669.0
2019-05-23 08:00:00	IWM	ETF	151.12	151.26	150.93	151.1	143425.0
2019-05-23 09:00:00	IWM	ETF	151.1	151.12	149.62	149.835	2708295.0
2019-05-23 10:00:00	IWM	ETF	149.84	150.653	149.6316	150.5	3407668.0
2019-05-23 11:00:00	IWM	ETF	150.51	150.53	149.411	149.47	1659208.0
2019-05-23 12:00:00	IWM	ETF	149.47	149.96	149.2058	149.27	1716583.0
2019-05-23 13:00:00	IWM	ETF	149.27	149.585	149.12	149.305	2271550.0
2019-05-23 14:00:00	IWM	ETF	149.3	149.44	148.74	148.89	1927600.0
2019-05-23 15:00:00	IWM	ETF	148.89	149.61	148.58	149.46	4935678.0
2019-05-23 16:00:00	IWM	ETF	149.46	152.5067	149.28	149.54	2128038.0
2019-05-23 17:00:00	IWM	ETF	149.5	149.5	149.39	149.39	122916.0
2019-05-23 18:00:00	IWM	ETF	149.57	149.7	149.57	149.61	14930.0
2019-05-23 19:00:00	IWM	ETF	149.55	149.7	149.51	149.7	10400.0
2019-05-23 04:00:00	DIA	ETF	256.2	256.2	256.2	256.2	200.0
2019-05-23 05:00:00	DIA	ETF	255.59	255.59	255.4	255.4	350.0

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

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