PREVIEW / etf_1hour / 2020-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-14.parquet
  size:    366 KB
  rows:    12,608

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-05-14 04:00:00	SPY	ETF	281.36	281.65	280.77	281.22	100362.0
2020-05-14 05:00:00	SPY	ETF	281.22	282.1	281.03	282.1	112861.0
2020-05-14 06:00:00	SPY	ETF	281.98	281.98	280.74	281.46	190130.0
2020-05-14 07:00:00	SPY	ETF	281.5	281.7	279.81	279.99	1009888.0
2020-05-14 08:00:00	SPY	ETF	279.99	282.33	278.1	278.94	1979945.0
2020-05-14 09:00:00	SPY	ETF	278.9	279.78	272.99	276.89	16625628.0
2020-05-14 10:00:00	SPY	ETF	276.89	280.62	276.37	279.87	21702253.0
2020-05-14 11:00:00	SPY	ETF	279.87	281.62	279.02	279.7698	18183651.0
2020-05-14 12:00:00	SPY	ETF	279.785	282.64	279.4	282.4057	11086091.0
2020-05-14 13:00:00	SPY	ETF	282.42	283.65	281.8201	282.09	9972412.0
2020-05-14 14:00:00	SPY	ETF	282.08	282.7	281.05	282.18	9582940.0
2020-05-14 15:00:00	SPY	ETF	282.18	285.11	281.93	285.05	23842484.0
2020-05-14 16:00:00	SPY	ETF	285.05	285.73	284.8	285.17	6087865.0
2020-05-14 17:00:00	SPY	ETF	285.05	285.2	284.84	285.19	320946.0
2020-05-14 18:00:00	SPY	ETF	285.07	285.22	284.56	284.75	269620.0
2020-05-14 19:00:00	SPY	ETF	284.75	285.8	284.61	285.68	231906.0
2020-05-14 04:00:00	QQQ	ETF	219.67	220.01	219.24	219.87	56295.0
2020-05-14 05:00:00	QQQ	ETF	219.71	220.58	219.71	220.51	47005.0
2020-05-14 06:00:00	QQQ	ETF	220.44	220.44	219.36	219.43	19138.0
2020-05-14 07:00:00	QQQ	ETF	219.63	219.82	218.01	218.11	237254.0
2020-05-14 08:00:00	QQQ	ETF	218.1	220.35	217.0198	217.98	530832.0
2020-05-14 09:00:00	QQQ	ETF	218.0	219.09	216.13	216.54	6416993.0
2020-05-14 10:00:00	QQQ	ETF	216.6	217.97	215.99	217.3206	8126994.0
2020-05-14 11:00:00	QQQ	ETF	217.35	219.07	217.1601	217.31	8050937.0
2020-05-14 12:00:00	QQQ	ETF	217.345	219.32	217.04	219.18	4764935.0
2020-05-14 13:00:00	QQQ	ETF	219.22	219.94	218.67	219.0	3834400.0
2020-05-14 14:00:00	QQQ	ETF	219.0	219.45	218.17	219.35	4205463.0
2020-05-14 15:00:00	QQQ	ETF	219.3401	221.87	219.135	221.83	8571684.0
2020-05-14 16:00:00	QQQ	ETF	221.79	222.21	221.52	221.85	886762.0
2020-05-14 17:00:00	QQQ	ETF	221.91	221.95	221.62	221.88	215958.0
2020-05-14 18:00:00	QQQ	ETF	221.83	221.98	221.49	221.64	84455.0
2020-05-14 19:00:00	QQQ	ETF	221.53	222.39	221.51	222.34	127084.0
2020-05-14 04:00:00	IWM	ETF	122.0	122.37	121.87	121.94	8993.0
2020-05-14 05:00:00	IWM	ETF	122.46	122.47	122.31	122.31	1550.0
2020-05-14 06:00:00	IWM	ETF	122.15	122.15	121.44	121.49	78882.0
2020-05-14 07:00:00	IWM	ETF	121.67	121.85	120.59	120.75	260217.0
2020-05-14 08:00:00	IWM	ETF	120.69	122.65	118.98	119.46	454349.0
2020-05-14 09:00:00	IWM	ETF	119.42	120.36	117.46	117.64	8410303.0
2020-05-14 10:00:00	IWM	ETF	117.65	121.68	117.18	120.64	10358019.0
2020-05-14 11:00:00	IWM	ETF	120.64	122.06	119.62	120.44	7397969.0
2020-05-14 12:00:00	IWM	ETF	120.46	122.13	120.11	121.99	3768011.0
2020-05-14 13:00:00	IWM	ETF	121.99	122.86	121.32	121.35	4311333.0
2020-05-14 14:00:00	IWM	ETF	121.36	121.84	120.79	121.5	3660522.0
2020-05-14 15:00:00	IWM	ETF	121.5	123.27	121.38	123.22	7708802.0
2020-05-14 16:00:00	IWM	ETF	123.22	123.76	122.0	123.3	2541280.0
2020-05-14 17:00:00	IWM	ETF	123.3	123.48	123.0	123.12	76869.0
2020-05-14 18:00:00	IWM	ETF	123.12	123.34	122.95	123.15	47293.0
2020-05-14 19:00:00	IWM	ETF	123.15	123.83	123.14	123.8	44930.0
2020-05-14 04:00:00	DIA	ETF	232.17	232.49	232.16	232.26	3200.0
2020-05-14 05:00:00	DIA	ETF	232.74	233.0	232.66	233.0	1500.0

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

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