PREVIEW / etf_30min / 2020-09-22

all etf 30-min files

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

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-09-22 04:00:00	SPY	ETF	326.64	327.52	326.61	327.09	23512.0
2020-09-22 04:30:00	SPY	ETF	327.2	327.28	326.45	326.77	25953.0
2020-09-22 05:00:00	SPY	ETF	326.88	328.0	326.88	327.8	15560.0
2020-09-22 05:30:00	SPY	ETF	327.78	327.92	327.67	327.77	9017.0
2020-09-22 06:00:00	SPY	ETF	327.73	328.06	327.44	328.06	39091.0
2020-09-22 06:30:00	SPY	ETF	328.08	328.23	327.8	327.83	20963.0
2020-09-22 07:00:00	SPY	ETF	327.83	328.42	327.58	328.42	104701.0
2020-09-22 07:30:00	SPY	ETF	328.43	328.58	326.73	327.07	331490.0
2020-09-22 08:00:00	SPY	ETF	327.07	328.62	326.14	327.38	324155.0
2020-09-22 08:30:00	SPY	ETF	327.38	328.09	327.35	327.72	181729.0
2020-09-22 09:00:00	SPY	ETF	327.72	328.59	327.72	328.57	189181.0
2020-09-22 09:30:00	SPY	ETF	328.57	329.15	327.0	327.47	7578571.0
2020-09-22 10:00:00	SPY	ETF	327.47	328.82	327.35	328.8	5143008.0
2020-09-22 10:30:00	SPY	ETF	328.78	328.96	326.2889	326.3236	4294404.0
2020-09-22 11:00:00	SPY	ETF	326.34	327.36	325.86	327.16	5086035.0
2020-09-22 11:30:00	SPY	ETF	327.17	327.72	326.3	327.62	2481805.0
2020-09-22 12:00:00	SPY	ETF	327.61	328.3	327.5664	328.05	2203281.0
2020-09-22 12:30:00	SPY	ETF	328.0559	328.22	326.93	327.31	2181876.0
2020-09-22 13:00:00	SPY	ETF	327.3	328.4	327.16	328.325	2482085.0
2020-09-22 13:30:00	SPY	ETF	328.32	329.13	328.16	329.08	2616606.0
2020-09-22 14:00:00	SPY	ETF	329.09	329.87	329.09	329.41	4519811.0
2020-09-22 14:30:00	SPY	ETF	329.425	329.67	329.05	329.18	2357715.0
2020-09-22 15:00:00	SPY	ETF	329.2	330.31	328.92	330.23	3690845.0
2020-09-22 15:30:00	SPY	ETF	330.24	330.9	329.66	330.33	11023502.0
2020-09-22 16:00:00	SPY	ETF	330.33	330.386	329.59	330.0	3600008.0
2020-09-22 16:30:00	SPY	ETF	330.0	330.3	329.82	330.07	305258.0
2020-09-22 17:00:00	SPY	ETF	330.06	330.3	330.02	330.03	26884.0
2020-09-22 17:30:00	SPY	ETF	330.03	330.24	330.0	330.14	39685.0
2020-09-22 18:00:00	SPY	ETF	330.2	330.3	329.6	329.78	59794.0
2020-09-22 18:30:00	SPY	ETF	329.86	330.32	329.44	329.55	65325.0
2020-09-22 19:00:00	SPY	ETF	329.41	329.61	329.34	329.55	22078.0
2020-09-22 19:30:00	SPY	ETF	329.58	330.2	329.5	330.16	76486.0
2020-09-22 04:00:00	QQQ	ETF	267.41	268.79	267.26	268.49	23161.0
2020-09-22 04:30:00	QQQ	ETF	268.35	268.71	267.87	268.42	28770.0
2020-09-22 05:00:00	QQQ	ETF	268.36	269.83	268.36	269.69	15612.0
2020-09-22 05:30:00	QQQ	ETF	269.74	270.0	269.52	269.6	9862.0
2020-09-22 06:00:00	QQQ	ETF	269.38	270.15	269.21	270.15	15114.0
2020-09-22 06:30:00	QQQ	ETF	270.2	270.3	269.62	269.77	8883.0
2020-09-22 07:00:00	QQQ	ETF	269.51	270.03	269.16	270.0	44626.0
2020-09-22 07:30:00	QQQ	ETF	269.93	269.93	268.24	268.47	83205.0
2020-09-22 08:00:00	QQQ	ETF	269.5389	269.99	266.27	268.99	146041.0
2020-09-22 08:30:00	QQQ	ETF	269.03	269.85	269.03	269.54	171264.0
2020-09-22 09:00:00	QQQ	ETF	269.53	270.2	269.53	270.09	186790.0
2020-09-22 09:30:00	QQQ	ETF	270.08	270.23	267.21	268.59	4972208.0
2020-09-22 10:00:00	QQQ	ETF	268.6	269.63	268.21	269.39	2817575.0
2020-09-22 10:30:00	QQQ	ETF	269.39	269.71	267.06	267.11	1948045.0
2020-09-22 11:00:00	QQQ	ETF	267.13	268.42	266.54	268.16	2292366.0
2020-09-22 11:30:00	QQQ	ETF	268.18	268.94	267.42	268.85	1194913.0
2020-09-22 12:00:00	QQQ	ETF	268.84	269.67	268.78	269.6011	1250817.0
2020-09-22 12:30:00	QQQ	ETF	269.61	269.93	268.52	268.94	1317605.0

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

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