PREVIEW / etf_30min / 2020-10-22

all etf 30-min files

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

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-22 04:00:00	SPY	ETF	341.94	342.67	341.69	342.67	24967.0
2020-10-22 04:30:00	SPY	ETF	342.7	342.72	342.16	342.3	16849.0
2020-10-22 05:00:00	SPY	ETF	342.33	342.33	342.04	342.13	15301.0
2020-10-22 05:30:00	SPY	ETF	342.17	342.38	342.04	342.19	3391.0
2020-10-22 06:00:00	SPY	ETF	342.02	342.77	341.82	342.77	19663.0
2020-10-22 06:30:00	SPY	ETF	342.7	342.84	342.33	342.58	44831.0
2020-10-22 07:00:00	SPY	ETF	342.56	342.85	342.44	342.64	104270.0
2020-10-22 07:30:00	SPY	ETF	342.64	342.84	342.3	342.75	103035.0
2020-10-22 08:00:00	SPY	ETF	342.7899	343.07	340.51	342.46	201884.0
2020-10-22 08:30:00	SPY	ETF	342.6	342.98	342.2	342.39	401554.0
2020-10-22 09:00:00	SPY	ETF	342.4	343.0	342.28	342.92	212889.0
2020-10-22 09:30:00	SPY	ETF	342.96	343.77	342.92	343.43	3613867.0
2020-10-22 10:00:00	SPY	ETF	343.42	343.5998	341.565	341.93	3095090.0
2020-10-22 10:30:00	SPY	ETF	341.925	342.45	340.65	342.24	6597937.0
2020-10-22 11:00:00	SPY	ETF	342.22	343.46	342.09	342.94	3669150.0
2020-10-22 11:30:00	SPY	ETF	342.94	343.075	342.13	342.3	2928242.0
2020-10-22 12:00:00	SPY	ETF	342.31	342.82	341.96	342.65	2078759.0
2020-10-22 12:30:00	SPY	ETF	342.655	343.29	342.05	343.12	1712767.0
2020-10-22 13:00:00	SPY	ETF	343.12	344.36	343.03	343.8477	2304637.0
2020-10-22 13:30:00	SPY	ETF	343.84	344.54	343.48	344.33	4054791.0
2020-10-22 14:00:00	SPY	ETF	344.33	345.04	344.2524	344.59	2503187.0
2020-10-22 14:30:00	SPY	ETF	344.59	344.863	344.33	344.45	2086293.0
2020-10-22 15:00:00	SPY	ETF	344.45	344.76	343.89	344.74	3301236.0
2020-10-22 15:30:00	SPY	ETF	344.75	345.24	344.15	344.63	9562657.0
2020-10-22 16:00:00	SPY	ETF	344.67	344.99	344.33	344.64	4932193.0
2020-10-22 16:30:00	SPY	ETF	344.64	345.01	344.5	345.0	249408.0
2020-10-22 17:00:00	SPY	ETF	344.94	345.09	344.85	345.05	39799.0
2020-10-22 17:30:00	SPY	ETF	345.09	345.28	345.04	345.28	78018.0
2020-10-22 18:00:00	SPY	ETF	345.29	345.56	345.22	345.37	90712.0
2020-10-22 18:30:00	SPY	ETF	345.36	345.56	345.28	345.36	40499.0
2020-10-22 19:00:00	SPY	ETF	345.36	345.3799	344.8	345.16	40383.0
2020-10-22 19:30:00	SPY	ETF	345.17	345.38	345.01	345.1	31507.0
2020-10-22 04:00:00	QQQ	ETF	283.95	284.62	283.8	284.62	22504.0
2020-10-22 04:30:00	QQQ	ETF	284.5	284.5	284.23	284.23	11117.0
2020-10-22 05:00:00	QQQ	ETF	284.3	284.3	284.12	284.15	4600.0
2020-10-22 05:30:00	QQQ	ETF	284.2	284.5	284.18	284.43	4410.0
2020-10-22 06:00:00	QQQ	ETF	284.27	284.83	283.9	284.82	19491.0
2020-10-22 06:30:00	QQQ	ETF	284.79	285.0	284.56	284.75	28145.0
2020-10-22 07:00:00	QQQ	ETF	284.79	284.98	284.62	284.73	55814.0
2020-10-22 07:30:00	QQQ	ETF	284.78	284.93	284.52	284.82	41712.0
2020-10-22 08:00:00	QQQ	ETF	284.74	285.29	283.48	284.66	173237.0
2020-10-22 08:30:00	QQQ	ETF	284.8	285.18	284.47	284.61	125470.0
2020-10-22 09:00:00	QQQ	ETF	284.61	285.1	284.55	285.05	151929.0
2020-10-22 09:30:00	QQQ	ETF	285.05	285.98	284.5628	284.815	2558566.0
2020-10-22 10:00:00	QQQ	ETF	284.8	284.9599	282.34	282.72	2556390.0
2020-10-22 10:30:00	QQQ	ETF	282.73	282.84	280.82	282.17	3919162.0
2020-10-22 11:00:00	QQQ	ETF	282.14	283.31	281.71	283.09	2363190.0
2020-10-22 11:30:00	QQQ	ETF	283.11	283.41	282.4	282.52	1572939.0
2020-10-22 12:00:00	QQQ	ETF	282.56	282.91	282.04	282.4972	844697.0
2020-10-22 12:30:00	QQQ	ETF	282.4874	283.23	281.65	283.12	1181677.0

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

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