PREVIEW / etf_30min / 2021-06-17

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-17.parquet
  size:    619 KB
  rows:    23,861

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
2021-06-17 04:00:00	SPY	ETF	420.26	420.86	420.22	420.57	8001.0
2021-06-17 04:30:00	SPY	ETF	420.62	420.63	419.91	420.1	3198.0
2021-06-17 05:00:00	SPY	ETF	420.12	420.73	420.12	420.58	9866.0
2021-06-17 05:30:00	SPY	ETF	420.59	420.78	420.42	420.78	6770.0
2021-06-17 06:00:00	SPY	ETF	420.78	420.96	420.7	420.7	8272.0
2021-06-17 06:30:00	SPY	ETF	420.68	420.73	420.32	420.73	25343.0
2021-06-17 07:00:00	SPY	ETF	420.71	421.42	420.71	421.29	83886.0
2021-06-17 07:30:00	SPY	ETF	421.3	421.34	420.56	420.59	55144.0
2021-06-17 08:00:00	SPY	ETF	420.58	421.38	420.1	420.35	215873.0
2021-06-17 08:30:00	SPY	ETF	420.4	420.87	420.38	420.76	197832.0
2021-06-17 09:00:00	SPY	ETF	420.78	421.97	420.7	421.65	634331.0
2021-06-17 09:30:00	SPY	ETF	421.67	422.9	421.6	421.835	6201886.0
2021-06-17 10:00:00	SPY	ETF	421.84	422.29	421.1	422.0	4752008.0
2021-06-17 10:30:00	SPY	ETF	422.02	422.9325	421.7	421.8899	3587089.0
2021-06-17 11:00:00	SPY	ETF	421.88	422.12	421.27	422.0511	3221937.0
2021-06-17 11:30:00	SPY	ETF	422.06	422.62	421.17	421.28	3134516.0
2021-06-17 12:00:00	SPY	ETF	421.29	421.415	419.39	419.66	4742448.0
2021-06-17 12:30:00	SPY	ETF	419.66	421.12	419.32	421.12	3928333.0
2021-06-17 13:00:00	SPY	ETF	421.115	422.26	421.07	422.25	3027250.0
2021-06-17 13:30:00	SPY	ETF	422.25	422.62	421.93	422.19	2813824.0
2021-06-17 14:00:00	SPY	ETF	422.18	422.36	421.86	422.22	2365114.0
2021-06-17 14:30:00	SPY	ETF	422.24	422.27	421.64	421.81	2182002.0
2021-06-17 15:00:00	SPY	ETF	421.815	422.74	421.5827	422.59	2932350.0
2021-06-17 15:30:00	SPY	ETF	422.58	423.02	421.82	421.98	8784803.0
2021-06-17 16:00:00	SPY	ETF	421.99	422.26	421.92	421.99	3769688.0
2021-06-17 16:30:00	SPY	ETF	422.02	422.36	421.97	422.26	174414.0
2021-06-17 17:00:00	SPY	ETF	422.0	422.17	421.97	422.15	98519.0
2021-06-17 17:30:00	SPY	ETF	422.15	422.24	421.97	422.24	4043446.0
2021-06-17 18:00:00	SPY	ETF	422.23	422.41	422.17	422.41	68849.0
2021-06-17 18:30:00	SPY	ETF	422.36	422.62	422.36	422.56	9082.0
2021-06-17 19:00:00	SPY	ETF	422.5	422.55	422.42	422.5	2730.0
2021-06-17 19:30:00	SPY	ETF	422.4501	422.61	422.17	422.31	39212.0
2021-06-17 04:00:00	QQQ	ETF	338.92	339.38	338.67	339.1	36552.0
2021-06-17 04:30:00	QQQ	ETF	339.11	339.15	338.4	338.65	38275.0
2021-06-17 05:00:00	QQQ	ETF	338.67	339.13	338.6	339.07	18550.0
2021-06-17 05:30:00	QQQ	ETF	339.06	339.3	338.93	339.29	13173.0
2021-06-17 06:00:00	QQQ	ETF	339.29	339.52	339.15	339.18	30438.0
2021-06-17 06:30:00	QQQ	ETF	339.2	339.3	338.7	339.27	51814.0
2021-06-17 07:00:00	QQQ	ETF	339.24	339.94	339.2	339.84	115352.0
2021-06-17 07:30:00	QQQ	ETF	339.89	339.91	339.18	339.22	72093.0
2021-06-17 08:00:00	QQQ	ETF	339.21	341.265	338.69	338.98	159645.0
2021-06-17 08:30:00	QQQ	ETF	339.1	339.61	339.1	339.38	110183.0
2021-06-17 09:00:00	QQQ	ETF	339.46	340.07	339.27	340.0204	191331.0
2021-06-17 09:30:00	QQQ	ETF	339.97	342.39	339.92	342.16	3888768.0
2021-06-17 10:00:00	QQQ	ETF	342.18	343.9	341.95	343.76	3476841.0
2021-06-17 10:30:00	QQQ	ETF	343.8	344.68	343.65	344.04	3539553.0
2021-06-17 11:00:00	QQQ	ETF	344.045	345.52	343.96	345.45	3736933.0
2021-06-17 11:30:00	QQQ	ETF	345.455	346.2	344.845	344.99	4461068.0
2021-06-17 12:00:00	QQQ	ETF	345.0	345.26	343.1975	343.37	3589968.0
2021-06-17 12:30:00	QQQ	ETF	343.37	344.33	343.02	344.13	2572539.0

> showing 50 of 23,861 rows — these rows as CSV

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