PREVIEW / etf_30min / 2021-03-18

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-18.parquet
  size:    633 KB
  rows:    24,072

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-03-18 04:00:00	SPY	ETF	396.09	398.0	395.81	395.94	39463.0
2021-03-18 04:30:00	SPY	ETF	395.94	395.94	394.9	395.12	117979.0
2021-03-18 05:00:00	SPY	ETF	395.05	395.55	395.04	395.34	29932.0
2021-03-18 05:30:00	SPY	ETF	395.39	395.74	395.19	395.41	32619.0
2021-03-18 06:00:00	SPY	ETF	395.29	395.81	395.29	395.79	25462.0
2021-03-18 06:30:00	SPY	ETF	395.75	396.09	395.65	395.65	119421.0
2021-03-18 07:00:00	SPY	ETF	395.7	395.84	395.18	395.27	243509.0
2021-03-18 07:30:00	SPY	ETF	395.29	395.34	394.15	394.59	309458.0
2021-03-18 08:00:00	SPY	ETF	395.3801	398.253	394.17	394.63	282510.0
2021-03-18 08:30:00	SPY	ETF	394.54	394.89	394.36	394.67	335669.0
2021-03-18 09:00:00	SPY	ETF	394.65	394.68	394.07	394.46	237098.0
2021-03-18 09:30:00	SPY	ETF	394.47	395.41	394.02	395.22	8126774.0
2021-03-18 10:00:00	SPY	ETF	395.21	395.33	394.18	395.0481	5708540.0
2021-03-18 10:30:00	SPY	ETF	395.045	395.58	394.52	395.2	4134832.0
2021-03-18 11:00:00	SPY	ETF	395.2	395.83	395.1	395.825	3217138.0
2021-03-18 11:30:00	SPY	ETF	395.825	395.97	395.36	395.94	3104774.0
2021-03-18 12:00:00	SPY	ETF	395.935	396.72	395.86	396.3	2601442.0
2021-03-18 12:30:00	SPY	ETF	396.3	396.36	394.42	394.665	3316302.0
2021-03-18 13:00:00	SPY	ETF	394.66	395.73	394.62	395.5925	2605757.0
2021-03-18 13:30:00	SPY	ETF	395.61	396.13	395.33	396.03	2116807.0
2021-03-18 14:00:00	SPY	ETF	396.03	396.085	393.86	393.9199	4931897.0
2021-03-18 14:30:00	SPY	ETF	393.92	394.24	392.205	393.34	8742638.0
2021-03-18 15:00:00	SPY	ETF	393.345	393.5896	391.97	392.81	7673175.0
2021-03-18 15:30:00	SPY	ETF	392.82	392.99	390.75	391.41	17541230.0
2021-03-18 16:00:00	SPY	ETF	391.41	392.5	391.2947	391.96	6525879.0
2021-03-18 16:30:00	SPY	ETF	391.96	391.99	391.6	391.86	577623.0
2021-03-18 17:00:00	SPY	ETF	391.9899	392.2	391.48	392.19	642993.0
2021-03-18 17:30:00	SPY	ETF	392.16	392.22	391.71	392.08	41785.0
2021-03-18 18:00:00	SPY	ETF	392.06	392.45	391.72	391.97	83181.0
2021-03-18 18:30:00	SPY	ETF	391.48	392.05	391.48	391.52	80332.0
2021-03-18 19:00:00	SPY	ETF	391.51	392.04	391.46	392.02	59661.0
2021-03-18 19:30:00	SPY	ETF	392.02	392.07	391.7	391.86	43604.0
2021-03-18 04:00:00	QQQ	ETF	321.33	321.33	318.66	319.24	133234.0
2021-03-18 04:30:00	QQQ	ETF	319.21	319.22	317.49	317.5	97766.0
2021-03-18 05:00:00	QQQ	ETF	317.56	318.29	317.39	317.98	71176.0
2021-03-18 05:30:00	QQQ	ETF	317.98	318.66	317.93	318.13	45303.0
2021-03-18 06:00:00	QQQ	ETF	318.08	318.64	317.93	318.56	64649.0
2021-03-18 06:30:00	QQQ	ETF	318.52	318.78	318.28	318.28	84428.0
2021-03-18 07:00:00	QQQ	ETF	318.32	318.46	317.7	317.94	380581.0
2021-03-18 07:30:00	QQQ	ETF	317.91	317.94	316.16	316.73	884081.0
2021-03-18 08:00:00	QQQ	ETF	316.7	323.32	316.2	316.95	500667.0
2021-03-18 08:30:00	QQQ	ETF	316.9	316.99	316.29	316.621	382623.0
2021-03-18 09:00:00	QQQ	ETF	316.63	316.89	316.05	316.82	421847.0
2021-03-18 09:30:00	QQQ	ETF	316.87	317.8801	315.74	317.26	7854301.0
2021-03-18 10:00:00	QQQ	ETF	317.23	317.24	315.31	316.315	4668760.0
2021-03-18 10:30:00	QQQ	ETF	316.31	317.15	315.62	316.56	3591983.0
2021-03-18 11:00:00	QQQ	ETF	316.56	317.09	315.905	316.675	2855763.0
2021-03-18 11:30:00	QQQ	ETF	316.68	316.77	315.65	316.252	3012457.0
2021-03-18 12:00:00	QQQ	ETF	316.25	317.59	316.01	317.2	2771186.0
2021-03-18 12:30:00	QQQ	ETF	317.18	317.27	314.87	314.96	3337125.0

> showing 50 of 24,072 rows — these rows as CSV

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