PREVIEW / etf_1hour / 2019-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-05.parquet
  size:    373 KB
  rows:    12,368

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-08-05 04:00:00	SPY	ETF	289.7	289.7	288.6	288.63	50526.0
2019-08-05 05:00:00	SPY	ETF	288.5	289.75	288.31	289.5	121793.0
2019-08-05 06:00:00	SPY	ETF	289.5	289.66	288.85	288.93	160524.0
2019-08-05 07:00:00	SPY	ETF	288.93	289.19	288.24	289.01	706218.0
2019-08-05 08:00:00	SPY	ETF	289.04	292.62	288.14	288.23	1520676.0
2019-08-05 09:00:00	SPY	ETF	288.23	288.43	286.71	287.302	17677117.0
2019-08-05 10:00:00	SPY	ETF	287.29	287.42	285.73	286.41	19024511.0
2019-08-05 11:00:00	SPY	ETF	286.42	287.34	286.07	286.1	15536737.0
2019-08-05 12:00:00	SPY	ETF	286.1	286.32	284.22	284.32	14606884.0
2019-08-05 13:00:00	SPY	ETF	284.33	285.51	284.1	284.1317	12869652.0
2019-08-05 14:00:00	SPY	ETF	284.135	284.4796	282.6	282.79	19823180.0
2019-08-05 15:00:00	SPY	ETF	282.78	284.79	281.72	284.04	50604441.0
2019-08-05 16:00:00	SPY	ETF	284.03	292.7433	281.94	282.18	19337712.0
2019-08-05 17:00:00	SPY	ETF	282.18	283.82	281.09	281.4	445027.0
2019-08-05 18:00:00	SPY	ETF	281.4	281.48	278.0	278.5399	1570442.0
2019-08-05 19:00:00	SPY	ETF	278.5	279.21	277.37	277.94	515412.0
2019-08-05 04:00:00	QQQ	ETF	184.91	184.91	184.04	184.05	58825.0
2019-08-05 05:00:00	QQQ	ETF	184.07	184.89	183.82	184.64	122512.0
2019-08-05 06:00:00	QQQ	ETF	184.59	184.75	184.18	184.33	86660.0
2019-08-05 07:00:00	QQQ	ETF	184.27	184.34	183.66	184.17	260292.0
2019-08-05 08:00:00	QQQ	ETF	184.05	185.0	183.35	183.46	659631.0
2019-08-05 09:00:00	QQQ	ETF	183.42	183.7701	182.1	182.87	10642062.0
2019-08-05 10:00:00	QQQ	ETF	182.87	183.0	181.61	182.13	8358128.0
2019-08-05 11:00:00	QQQ	ETF	182.13	182.85	181.74	181.8	5869928.0
2019-08-05 12:00:00	QQQ	ETF	181.7793	181.97	180.55	180.63	7016942.0
2019-08-05 13:00:00	QQQ	ETF	180.62	181.59	180.4735	180.51	5020180.0
2019-08-05 14:00:00	QQQ	ETF	180.5	180.71	179.6	179.76	7164842.0
2019-08-05 15:00:00	QQQ	ETF	179.75	181.19	179.2	180.68	16707983.0
2019-08-05 16:00:00	QQQ	ETF	180.69	180.82	179.21	179.4	4698982.0
2019-08-05 17:00:00	QQQ	ETF	179.35	180.73	178.72	179.08	268770.0
2019-08-05 18:00:00	QQQ	ETF	178.83	178.89	176.51	176.83	512934.0
2019-08-05 19:00:00	QQQ	ETF	176.88	177.32	175.95	176.35	324435.0
2019-08-05 04:00:00	IWM	ETF	150.77	150.77	150.31	150.33	1683.0
2019-08-05 05:00:00	IWM	ETF	150.0	150.59	149.96	150.58	1393.0
2019-08-05 06:00:00	IWM	ETF	150.34	150.34	150.0	150.02	6600.0
2019-08-05 07:00:00	IWM	ETF	150.1	150.14	149.69	150.06	36800.0
2019-08-05 08:00:00	IWM	ETF	149.7601	150.61	149.67	149.75	120210.0
2019-08-05 09:00:00	IWM	ETF	149.64	149.92	148.75	149.03	4024941.0
2019-08-05 10:00:00	IWM	ETF	149.02	149.12	147.82	148.25	4013512.0
2019-08-05 11:00:00	IWM	ETF	148.24	148.895	148.14	148.51	2790250.0
2019-08-05 12:00:00	IWM	ETF	148.5	148.65	147.57	147.68	4185943.0
2019-08-05 13:00:00	IWM	ETF	147.6899	148.32	147.36	147.475	3419057.0
2019-08-05 14:00:00	IWM	ETF	147.45	147.62	146.8738	147.0	2985426.0
2019-08-05 15:00:00	IWM	ETF	147.005	148.41	146.2072	147.97	10779990.0
2019-08-05 16:00:00	IWM	ETF	147.96	148.1	146.82	146.93	2871855.0
2019-08-05 17:00:00	IWM	ETF	146.8	147.19	146.5	146.55	10872.0
2019-08-05 18:00:00	IWM	ETF	146.59	148.0	144.77	144.93	84532.0
2019-08-05 19:00:00	IWM	ETF	145.0	145.23	144.36	144.57	35174.0
2019-08-05 04:00:00	DIA	ETF	261.9	261.9	261.44	261.44	700.0
2019-08-05 05:00:00	DIA	ETF	261.12	262.16	261.12	262.1	2515.0

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

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