PREVIEW / etf_30min / 2021-05-13

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-13.parquet
  size:    625 KB
  rows:    24,174

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-13 04:00:00	SPY	ETF	403.96	404.46	403.45	403.8	66300.0
2021-05-13 04:30:00	SPY	ETF	403.71	403.83	402.7	403.67	62121.0
2021-05-13 05:00:00	SPY	ETF	403.79	404.54	403.51	404.44	40221.0
2021-05-13 05:30:00	SPY	ETF	404.54	404.82	404.26	404.32	28649.0
2021-05-13 06:00:00	SPY	ETF	404.29	404.3	403.4	404.12	69366.0
2021-05-13 06:30:00	SPY	ETF	404.22	404.52	403.74	404.43	60414.0
2021-05-13 07:00:00	SPY	ETF	404.35	405.56	404.17	405.55	187742.0
2021-05-13 07:30:00	SPY	ETF	405.5	406.25	405.47	405.66	533362.0
2021-05-13 08:00:00	SPY	ETF	405.65	406.96	403.6104	406.36	467999.0
2021-05-13 08:30:00	SPY	ETF	406.3	407.17	405.85	406.6	751609.0
2021-05-13 09:00:00	SPY	ETF	406.6	407.37	406.56	407.05	467714.0
2021-05-13 09:30:00	SPY	ETF	407.07	410.07	407.02	410.04	10354715.0
2021-05-13 10:00:00	SPY	ETF	410.05	411.45	410.05	411.25	8365516.0
2021-05-13 10:30:00	SPY	ETF	411.24	412.02	410.66	411.81	5800221.0
2021-05-13 11:00:00	SPY	ETF	411.82	411.93	409.66	409.84	5757994.0
2021-05-13 11:30:00	SPY	ETF	409.84	410.6659	409.2101	409.665	5445379.0
2021-05-13 12:00:00	SPY	ETF	409.67	410.83	409.47	410.65	3531323.0
2021-05-13 12:30:00	SPY	ETF	410.65	411.13	409.55	409.86	4061516.0
2021-05-13 13:00:00	SPY	ETF	409.85	410.44	408.63	409.06	5280897.0
2021-05-13 13:30:00	SPY	ETF	409.06	409.25	407.84	408.8	6323552.0
2021-05-13 14:00:00	SPY	ETF	408.82	411.189	408.7599	411.14	5418221.0
2021-05-13 14:30:00	SPY	ETF	411.14	411.7	410.76	411.05	5572861.0
2021-05-13 15:00:00	SPY	ETF	411.05	411.9	410.82	411.63	5849104.0
2021-05-13 15:30:00	SPY	ETF	411.62	412.35	410.21	410.25	15042446.0
2021-05-13 16:00:00	SPY	ETF	410.26	410.438	409.86	410.16	3278010.0
2021-05-13 16:30:00	SPY	ETF	410.16	410.78	410.16	410.73	434372.0
2021-05-13 17:00:00	SPY	ETF	410.73	410.87	410.3955	410.6	194420.0
2021-05-13 17:30:00	SPY	ETF	410.6	410.84	410.55	410.7	119020.0
2021-05-13 18:00:00	SPY	ETF	410.78	410.9	410.46	410.55	76341.0
2021-05-13 18:30:00	SPY	ETF	410.28	410.8	410.28	410.67	28153.0
2021-05-13 19:00:00	SPY	ETF	410.63	411.07	410.48	410.92	26015.0
2021-05-13 19:30:00	SPY	ETF	410.85	411.17	410.22	411.0	72131.0
2021-05-13 04:00:00	QQQ	ETF	317.0	317.0	315.33	315.79	68095.0
2021-05-13 04:30:00	QQQ	ETF	315.69	315.88	314.96	315.79	49807.0
2021-05-13 05:00:00	QQQ	ETF	315.8	316.6	315.5	316.41	60458.0
2021-05-13 05:30:00	QQQ	ETF	316.45	316.51	315.83	315.93	28878.0
2021-05-13 06:00:00	QQQ	ETF	316.1	316.2	315.44	316.1	46435.0
2021-05-13 06:30:00	QQQ	ETF	316.13	316.42	315.76	316.14	68496.0
2021-05-13 07:00:00	QQQ	ETF	316.16	318.3	315.9	318.25	381712.0
2021-05-13 07:30:00	QQQ	ETF	318.2	319.01	318.12	318.29	577511.0
2021-05-13 08:00:00	QQQ	ETF	315.9396	319.15	315.5496	318.7001	368767.0
2021-05-13 08:30:00	QQQ	ETF	318.7	320.0	317.75	319.13	836035.0
2021-05-13 09:00:00	QQQ	ETF	319.17	320.27	319.17	319.93	571381.0
2021-05-13 09:30:00	QQQ	ETF	319.92	321.08	319.1	320.85	7391481.0
2021-05-13 10:00:00	QQQ	ETF	320.85	322.155	320.77	321.33	4894847.0
2021-05-13 10:30:00	QQQ	ETF	321.31	322.4	320.69	321.83	3011195.0
2021-05-13 11:00:00	QQQ	ETF	321.83	321.95	319.18	319.3299	4566148.0
2021-05-13 11:30:00	QQQ	ETF	319.321	320.105	318.38	318.91	4021813.0
2021-05-13 12:00:00	QQQ	ETF	318.9	320.2	318.71	320.02	2267908.0
2021-05-13 12:30:00	QQQ	ETF	320.01	320.53	318.6	318.7201	2347223.0

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

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