PREVIEW / etf_30min / 2020-08-25

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-25.parquet
  size:    553 KB
  rows:    20,283

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-08-25 04:00:00	SPY	ETF	344.57	344.6	344.12	344.12	14830.0
2020-08-25 04:30:00	SPY	ETF	344.15	344.15	343.88	344.09	7848.0
2020-08-25 05:00:00	SPY	ETF	343.82	344.16	343.82	344.16	6565.0
2020-08-25 05:30:00	SPY	ETF	344.06	344.15	343.99	344.14	3900.0
2020-08-25 06:00:00	SPY	ETF	344.14	344.17	343.96	344.05	8815.0
2020-08-25 06:30:00	SPY	ETF	344.05	344.32	344.02	344.26	8427.0
2020-08-25 07:00:00	SPY	ETF	344.25	344.42	344.0	344.08	85405.0
2020-08-25 07:30:00	SPY	ETF	344.1	344.44	344.08	344.29	57140.0
2020-08-25 08:00:00	SPY	ETF	344.33	344.59	343.7	344.3	122602.0
2020-08-25 08:30:00	SPY	ETF	344.29	344.31	344.0	344.11	43195.0
2020-08-25 09:00:00	SPY	ETF	344.1	344.23	343.46	343.54	201694.0
2020-08-25 09:30:00	SPY	ETF	343.53	343.7	342.86	343.35	4499765.0
2020-08-25 10:00:00	SPY	ETF	343.36	343.36	342.51	342.72	3407135.0
2020-08-25 10:30:00	SPY	ETF	342.72	342.94	342.27	342.745	2988628.0
2020-08-25 11:00:00	SPY	ETF	342.745	343.48	342.65	343.13	2840611.0
2020-08-25 11:30:00	SPY	ETF	343.14	343.2	342.35	342.71	1711559.0
2020-08-25 12:00:00	SPY	ETF	342.715	343.01	342.35	342.84	1742217.0
2020-08-25 12:30:00	SPY	ETF	342.855	343.155	342.72	343.06	1036883.0
2020-08-25 13:00:00	SPY	ETF	343.06	343.35	342.825	343.2828	909656.0
2020-08-25 13:30:00	SPY	ETF	343.28	343.39	343.15	343.19	1508064.0
2020-08-25 14:00:00	SPY	ETF	343.19	343.62	343.01	343.59	2004116.0
2020-08-25 14:30:00	SPY	ETF	343.59	343.8	343.5	343.7399	1556560.0
2020-08-25 15:00:00	SPY	ETF	343.735	344.09	343.53	344.045	2514523.0
2020-08-25 15:30:00	SPY	ETF	344.0418	344.21	343.89	344.0999	6199980.0
2020-08-25 16:00:00	SPY	ETF	344.09	344.42	343.5429	344.42	3795761.0
2020-08-25 16:30:00	SPY	ETF	344.4	344.57	344.09	344.45	177696.0
2020-08-25 17:00:00	SPY	ETF	344.57	344.57	344.29	344.35	97167.0
2020-08-25 17:30:00	SPY	ETF	344.35	344.5	344.34	344.5	32651.0
2020-08-25 18:00:00	SPY	ETF	344.49	344.59	344.4	344.4	66820.0
2020-08-25 18:30:00	SPY	ETF	344.44	344.4899	344.39	344.4899	16638.0
2020-08-25 19:00:00	SPY	ETF	344.47	344.56	344.4	344.56	14409.0
2020-08-25 19:30:00	SPY	ETF	344.59	344.74	344.55	344.55	39764.0
2020-08-25 04:00:00	QQQ	ETF	284.9	284.91	284.63	284.63	28508.0
2020-08-25 04:30:00	QQQ	ETF	284.4	284.6	284.3	284.47	9240.0
2020-08-25 05:00:00	QQQ	ETF	284.35	284.54	284.27	284.43	5025.0
2020-08-25 05:30:00	QQQ	ETF	284.47	284.52	284.36	284.36	2500.0
2020-08-25 06:00:00	QQQ	ETF	284.29	284.4	284.09	284.24	10750.0
2020-08-25 06:30:00	QQQ	ETF	284.29	284.46	284.17	284.17	11429.0
2020-08-25 07:00:00	QQQ	ETF	284.25	284.35	283.35	283.53	96921.0
2020-08-25 07:30:00	QQQ	ETF	283.5	283.83	283.39	283.46	40696.0
2020-08-25 08:00:00	QQQ	ETF	283.42	285.18	283.19	283.66	172897.0
2020-08-25 08:30:00	QQQ	ETF	283.66	283.67	283.33	283.55	182598.0
2020-08-25 09:00:00	QQQ	ETF	283.57	283.61	282.6	282.8	349267.0
2020-08-25 09:30:00	QQQ	ETF	282.78	283.77	282.37	283.51	5204149.0
2020-08-25 10:00:00	QQQ	ETF	283.52	284.1	282.69	283.335	2849300.0
2020-08-25 10:30:00	QQQ	ETF	283.35	284.18	282.945	284.045	2400266.0
2020-08-25 11:00:00	QQQ	ETF	284.06	285.22	283.911	284.58	2146859.0
2020-08-25 11:30:00	QQQ	ETF	284.58	284.65	283.82	284.36	1555778.0
2020-08-25 12:00:00	QQQ	ETF	284.37	284.49	283.58	284.2701	1204736.0
2020-08-25 12:30:00	QQQ	ETF	284.3	284.72	284.14	284.5288	940690.0

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

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