PREVIEW / etf_30min / 2021-05-10

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-10.parquet
  size:    642 KB
  rows:    24,634

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-05-10 04:00:00	SPY	ETF	422.26	422.5	422.24	422.44	7575.0
2021-05-10 04:30:00	SPY	ETF	422.36	422.37	422.07	422.08	9004.0
2021-05-10 05:00:00	SPY	ETF	422.09	422.4	422.09	422.25	3184.0
2021-05-10 05:30:00	SPY	ETF	422.12	422.22	422.0	422.16	43126.0
2021-05-10 06:00:00	SPY	ETF	422.16	422.39	422.16	422.39	3494.0
2021-05-10 06:30:00	SPY	ETF	422.17	422.52	422.13	422.44	15456.0
2021-05-10 07:00:00	SPY	ETF	422.48	422.66	422.45	422.6	49592.0
2021-05-10 07:30:00	SPY	ETF	422.56	422.56	422.31	422.4	69982.0
2021-05-10 08:00:00	SPY	ETF	422.3696	423.0	422.17	422.61	76202.0
2021-05-10 08:30:00	SPY	ETF	422.68	422.81	422.53	422.6	52673.0
2021-05-10 09:00:00	SPY	ETF	422.61	422.65	422.31	422.52	224615.0
2021-05-10 09:30:00	SPY	ETF	422.5	422.74	421.66	422.11	5255419.0
2021-05-10 10:00:00	SPY	ETF	422.12	422.43	421.67	421.689	3990055.0
2021-05-10 10:30:00	SPY	ETF	421.68	421.76	421.03	421.59	4484008.0
2021-05-10 11:00:00	SPY	ETF	421.5899	422.38	421.34	422.2111	3795579.0
2021-05-10 11:30:00	SPY	ETF	422.22	422.48	421.8	422.365	2126679.0
2021-05-10 12:00:00	SPY	ETF	422.37	422.65	422.08	422.14	2046278.0
2021-05-10 12:30:00	SPY	ETF	422.145	422.4	421.77	421.8011	1574249.0
2021-05-10 13:00:00	SPY	ETF	421.81	422.01	421.62	421.7238	1832489.0
2021-05-10 13:30:00	SPY	ETF	421.72	421.79	421.37	421.44	2084353.0
2021-05-10 14:00:00	SPY	ETF	421.44	421.52	419.48	419.77	6884741.0
2021-05-10 14:30:00	SPY	ETF	419.7758	419.88	418.74	419.355	7106628.0
2021-05-10 15:00:00	SPY	ETF	419.355	419.73	418.9	419.445	5449551.0
2021-05-10 15:30:00	SPY	ETF	419.44	419.8	417.81	417.99	14208385.0
2021-05-10 16:00:00	SPY	ETF	417.99	418.2	417.47	417.74	3320745.0
2021-05-10 16:30:00	SPY	ETF	417.79	417.99	416.86	417.18	393074.0
2021-05-10 17:00:00	SPY	ETF	417.3	417.44	417.17	417.32	62891.0
2021-05-10 17:30:00	SPY	ETF	417.37	417.4	417.3	417.32	58435.0
2021-05-10 18:00:00	SPY	ETF	417.33	417.72	417.33	417.6	125162.0
2021-05-10 18:30:00	SPY	ETF	417.94	418.08	417.57	418.0	62082.0
2021-05-10 19:00:00	SPY	ETF	418.02	418.14	417.7	417.8	25066.0
2021-05-10 19:30:00	SPY	ETF	417.8	417.96	417.74	417.96	35011.0
2021-05-10 04:00:00	QQQ	ETF	333.25	333.72	333.24	333.53	15088.0
2021-05-10 04:30:00	QQQ	ETF	333.38	333.45	332.93	333.03	9559.0
2021-05-10 05:00:00	QQQ	ETF	333.03	333.61	332.96	333.43	17095.0
2021-05-10 05:30:00	QQQ	ETF	333.41	333.41	333.09	333.38	18453.0
2021-05-10 06:00:00	QQQ	ETF	333.36	333.4	333.15	333.25	11701.0
2021-05-10 06:30:00	QQQ	ETF	333.23	333.37	332.82	333.35	25440.0
2021-05-10 07:00:00	QQQ	ETF	333.31	333.5	333.03	333.1	58148.0
2021-05-10 07:30:00	QQQ	ETF	333.1	333.1	332.62	332.74	104171.0
2021-05-10 08:00:00	QQQ	ETF	332.71	334.65	332.59	333.08	129146.0
2021-05-10 08:30:00	QQQ	ETF	333.1	333.53	333.1	333.12	134437.0
2021-05-10 09:00:00	QQQ	ETF	333.14	333.25	332.51	332.77	205703.0
2021-05-10 09:30:00	QQQ	ETF	332.78	332.96	329.44	329.97	6911132.0
2021-05-10 10:00:00	QQQ	ETF	329.99	330.45	329.18	329.5	4178958.0
2021-05-10 10:30:00	QQQ	ETF	329.49	329.74	328.12	328.73	3632862.0
2021-05-10 11:00:00	QQQ	ETF	328.73	329.23	328.08	329.003	3224867.0
2021-05-10 11:30:00	QQQ	ETF	329.01	329.66	328.61	329.59	1805672.0
2021-05-10 12:00:00	QQQ	ETF	329.6	330.19	329.41	329.62	1804902.0
2021-05-10 12:30:00	QQQ	ETF	329.62	329.63	329.03	329.1	1019697.0

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

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