PREVIEW / etf_30min / 2020-10-20

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-20.parquet
  size:    551 KB
  rows:    20,181

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-10-20 04:00:00	SPY	ETF	344.1	344.41	344.04	344.14	12330.0
2020-10-20 04:30:00	SPY	ETF	344.14	344.26	343.94	343.94	9892.0
2020-10-20 05:00:00	SPY	ETF	344.13	344.37	344.08	344.18	16311.0
2020-10-20 05:30:00	SPY	ETF	344.25	344.4	344.21	344.28	16450.0
2020-10-20 06:00:00	SPY	ETF	344.35	344.97	344.32	344.97	11639.0
2020-10-20 06:30:00	SPY	ETF	345.0	345.01	344.68	344.82	24465.0
2020-10-20 07:00:00	SPY	ETF	344.8	344.87	344.6	344.68	110888.0
2020-10-20 07:30:00	SPY	ETF	344.68	344.68	344.28	344.44	111946.0
2020-10-20 08:00:00	SPY	ETF	344.8	344.95	342.65	343.3	539781.0
2020-10-20 08:30:00	SPY	ETF	343.26	343.79	343.2	343.44	187400.0
2020-10-20 09:00:00	SPY	ETF	343.44	343.8	343.27	343.43	200795.0
2020-10-20 09:30:00	SPY	ETF	343.46	344.879	343.03	344.835	5303220.0
2020-10-20 10:00:00	SPY	ETF	344.82	345.28	343.96	344.29	3186063.0
2020-10-20 10:30:00	SPY	ETF	344.3	344.7	343.57	343.58	2901662.0
2020-10-20 11:00:00	SPY	ETF	343.59	343.98	342.64	343.62	3048559.0
2020-10-20 11:30:00	SPY	ETF	343.61	344.19	343.2501	344.1615	1749492.0
2020-10-20 12:00:00	SPY	ETF	344.17	344.58	344.1	344.1199	1365390.0
2020-10-20 12:30:00	SPY	ETF	344.12	345.76	344.02	345.08	5258756.0
2020-10-20 13:00:00	SPY	ETF	345.1	346.599	344.99	346.4	3097974.0
2020-10-20 13:30:00	SPY	ETF	346.41	346.88	345.38	345.7399	3453054.0
2020-10-20 14:00:00	SPY	ETF	345.735	346.33	345.16	345.55	3268842.0
2020-10-20 14:30:00	SPY	ETF	345.54	345.92	344.96	345.05	2340010.0
2020-10-20 15:00:00	SPY	ETF	345.06	345.5599	342.6701	344.24	6885280.0
2020-10-20 15:30:00	SPY	ETF	344.26	344.88	343.16	343.34	10167299.0
2020-10-20 16:00:00	SPY	ETF	343.35	343.63	342.62	343.09	3486553.0
2020-10-20 16:30:00	SPY	ETF	343.09	343.56	341.81	342.71	1542591.0
2020-10-20 17:00:00	SPY	ETF	342.74	343.38	342.7	343.0	257096.0
2020-10-20 17:30:00	SPY	ETF	343.03	343.31	343.0	343.24	44373.0
2020-10-20 18:00:00	SPY	ETF	343.3	344.01	343.3	343.36	150372.0
2020-10-20 18:30:00	SPY	ETF	343.37	344.18	343.06	344.11	99848.0
2020-10-20 19:00:00	SPY	ETF	344.09	344.84	343.93	344.52	206824.0
2020-10-20 19:30:00	SPY	ETF	344.52	344.67	344.16	344.39	66141.0
2020-10-20 04:00:00	QQQ	ETF	286.11	286.4	285.91	286.08	16871.0
2020-10-20 04:30:00	QQQ	ETF	286.0	286.06	285.8	285.9	13082.0
2020-10-20 05:00:00	QQQ	ETF	285.99	286.17	285.72	285.73	9320.0
2020-10-20 05:30:00	QQQ	ETF	285.85	286.05	285.83	286.05	10970.0
2020-10-20 06:00:00	QQQ	ETF	286.02	286.53	285.95	286.52	4598.0
2020-10-20 06:30:00	QQQ	ETF	286.66	286.66	286.32	286.45	49782.0
2020-10-20 07:00:00	QQQ	ETF	286.46	286.48	285.94	286.03	108990.0
2020-10-20 07:30:00	QQQ	ETF	286.03	286.1	285.72	285.89	112706.0
2020-10-20 08:00:00	QQQ	ETF	286.42	286.46	284.15	284.71	677158.0
2020-10-20 08:30:00	QQQ	ETF	284.69	285.16	284.67	284.8098	235919.0
2020-10-20 09:00:00	QQQ	ETF	284.79	285.09	284.53	284.56	179946.0
2020-10-20 09:30:00	QQQ	ETF	284.56	285.56	283.75	285.49	3378487.0
2020-10-20 10:00:00	QQQ	ETF	285.47	286.29	284.685	284.9099	2557953.0
2020-10-20 10:30:00	QQQ	ETF	284.93	285.58	283.83	283.86	1882539.0
2020-10-20 11:00:00	QQQ	ETF	283.85	284.69	282.95	284.14	1980384.0
2020-10-20 11:30:00	QQQ	ETF	284.17	284.975	283.55	284.95	1138961.0
2020-10-20 12:00:00	QQQ	ETF	284.94	285.44	284.76	285.18	840865.0
2020-10-20 12:30:00	QQQ	ETF	285.18	286.33	284.885	285.68	2044111.0

> showing 50 of 20,181 rows — these rows as CSV

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