PREVIEW / etf_1hour / 2020-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-13.parquet
  size:    414 KB
  rows:    13,959

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-03-13 04:00:00	SPY	ETF	257.99	260.14	253.35	254.4	293992.0
2020-03-13 05:00:00	SPY	ETF	254.8	258.56	253.28	258.41	312273.0
2020-03-13 06:00:00	SPY	ETF	258.41	259.05	256.79	258.72	386504.0
2020-03-13 07:00:00	SPY	ETF	258.64	260.9	258.25	260.53	1908536.0
2020-03-13 08:00:00	SPY	ETF	260.41	262.8	245.0	262.54	4344442.0
2020-03-13 09:00:00	SPY	ETF	262.57	264.11	248.11	256.56	39072010.0
2020-03-13 10:00:00	SPY	ETF	256.56	261.54	254.21	254.43	51889808.0
2020-03-13 11:00:00	SPY	ETF	254.44	257.1	249.58	252.98	40945331.0
2020-03-13 12:00:00	SPY	ETF	252.97	257.76	250.83	255.35	25815155.0
2020-03-13 13:00:00	SPY	ETF	255.32	260.12	254.06	259.33	21852313.0
2020-03-13 14:00:00	SPY	ETF	259.29	259.37	253.7	257.02	31022171.0
2020-03-13 15:00:00	SPY	ETF	256.98	271.08	253.24	270.93	77264740.0
2020-03-13 16:00:00	SPY	ETF	270.94	271.4897	256.2964	267.0	25520054.0
2020-03-13 17:00:00	SPY	ETF	267.04	269.32	266.94	268.98	2805094.0
2020-03-13 18:00:00	SPY	ETF	269.04	272.1	269.04	269.91	3015963.0
2020-03-13 19:00:00	SPY	ETF	269.91	270.3	267.11	267.45	389683.0
2020-03-13 04:00:00	QQQ	ETF	184.57	185.65	180.72	181.63	229248.0
2020-03-13 05:00:00	QQQ	ETF	181.43	184.4	180.64	184.38	159918.0
2020-03-13 06:00:00	QQQ	ETF	184.4	185.21	183.27	184.66	309574.0
2020-03-13 07:00:00	QQQ	ETF	184.62	187.0	184.62	186.65	675432.0
2020-03-13 08:00:00	QQQ	ETF	185.63	187.99	175.34	187.42	974800.0
2020-03-13 09:00:00	QQQ	ETF	187.42	188.78	182.33	183.47	14189549.0
2020-03-13 10:00:00	QQQ	ETF	183.42	186.67	181.84	181.86	21905681.0
2020-03-13 11:00:00	QQQ	ETF	181.87	183.81	178.13	180.8908	17074162.0
2020-03-13 12:00:00	QQQ	ETF	180.87	184.34	179.16	182.34	10238784.0
2020-03-13 13:00:00	QQQ	ETF	182.34	185.55	181.6	184.94	10898222.0
2020-03-13 14:00:00	QQQ	ETF	184.93	184.97	180.79	183.11	9617837.0
2020-03-13 15:00:00	QQQ	ETF	183.08	194.48	180.32	193.96	25245986.0
2020-03-13 16:00:00	QQQ	ETF	193.92	194.7	190.59	191.08	3807141.0
2020-03-13 17:00:00	QQQ	ETF	191.02	195.1224	190.44	191.5499	831388.0
2020-03-13 18:00:00	QQQ	ETF	191.55	193.79	191.51	192.5	920534.0
2020-03-13 19:00:00	QQQ	ETF	192.51	192.87	190.01	190.5	115028.0
2020-03-13 04:00:00	IWM	ETF	114.75	116.99	113.5	114.2	58114.0
2020-03-13 05:00:00	IWM	ETF	114.01	116.18	113.5	116.18	63752.0
2020-03-13 06:00:00	IWM	ETF	116.0	117.2	115.5	117.05	66745.0
2020-03-13 07:00:00	IWM	ETF	117.05	117.73	116.59	117.28	178249.0
2020-03-13 08:00:00	IWM	ETF	116.9601	118.2	110.83	117.95	214651.0
2020-03-13 09:00:00	IWM	ETF	117.95	119.25	113.26	114.61	5897990.0
2020-03-13 10:00:00	IWM	ETF	114.7014	117.64	113.46	113.64	5922803.0
2020-03-13 11:00:00	IWM	ETF	113.68	114.47	109.55	111.63	6369828.0
2020-03-13 12:00:00	IWM	ETF	111.63	115.29	109.8	114.15	6230010.0
2020-03-13 13:00:00	IWM	ETF	114.14	116.13	113.98	115.87	4414274.0
2020-03-13 14:00:00	IWM	ETF	115.875	115.875	113.77	114.95	4191746.0
2020-03-13 15:00:00	IWM	ETF	114.93	119.96	112.81	119.7	11590384.0
2020-03-13 16:00:00	IWM	ETF	119.71	121.33	118.26	119.2	3408504.0
2020-03-13 17:00:00	IWM	ETF	118.86	120.01	118.86	119.6	198673.0
2020-03-13 18:00:00	IWM	ETF	119.54	120.25	119.44	119.51	189019.0
2020-03-13 19:00:00	IWM	ETF	119.5	119.51	118.82	118.82	14232.0
2020-03-13 04:00:00	DIA	ETF	220.41	221.43	216.46	216.98	12824.0
2020-03-13 05:00:00	DIA	ETF	216.97	220.0	216.15	220.0	16539.0

> showing 50 of 13,959 rows — these rows as CSV

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