PREVIEW / etf_30min / 2021-05-20

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-20.parquet
  size:    595 KB
  rows:    22,738

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-20 04:00:00	SPY	ETF	410.48	410.59	409.82	409.82	9936.0
2021-05-20 04:30:00	SPY	ETF	409.82	410.0	408.9	409.03	28041.0
2021-05-20 05:00:00	SPY	ETF	408.93	409.2	408.28	408.5	15746.0
2021-05-20 05:30:00	SPY	ETF	408.53	408.85	408.29	408.82	81832.0
2021-05-20 06:00:00	SPY	ETF	408.8	409.1	408.55	409.02	14176.0
2021-05-20 06:30:00	SPY	ETF	409.15	409.47	409.1	409.47	32850.0
2021-05-20 07:00:00	SPY	ETF	409.48	410.28	409.44	410.14	120731.0
2021-05-20 07:30:00	SPY	ETF	410.05	410.31	410.03	410.18	47412.0
2021-05-20 08:00:00	SPY	ETF	409.61	411.1	408.7996	410.42	133955.0
2021-05-20 08:30:00	SPY	ETF	410.36	411.25	410.2	411.24	282273.0
2021-05-20 09:00:00	SPY	ETF	411.29	411.91	411.2	411.79	539985.0
2021-05-20 09:30:00	SPY	ETF	411.8	413.26	411.67	413.09	6872307.0
2021-05-20 10:00:00	SPY	ETF	413.09	413.695	412.965	413.66	4703568.0
2021-05-20 10:30:00	SPY	ETF	413.66	414.18	413.39	413.97	3346985.0
2021-05-20 11:00:00	SPY	ETF	413.98	414.88	413.97	414.855	2822051.0
2021-05-20 11:30:00	SPY	ETF	414.858	416.14	414.0	415.56	4317592.0
2021-05-20 12:00:00	SPY	ETF	415.56	415.6	414.65	414.7	3544745.0
2021-05-20 12:30:00	SPY	ETF	414.71	415.011	414.1	414.8311	3449335.0
2021-05-20 13:00:00	SPY	ETF	414.83	415.485	414.665	415.405	1963003.0
2021-05-20 13:30:00	SPY	ETF	415.41	415.5499	414.57	415.12	2306230.0
2021-05-20 14:00:00	SPY	ETF	415.13	415.57	415.09	415.57	2187253.0
2021-05-20 14:30:00	SPY	ETF	415.57	415.85	415.305	415.59	2791634.0
2021-05-20 15:00:00	SPY	ETF	415.59	416.625	415.23	416.6	4736269.0
2021-05-20 15:30:00	SPY	ETF	416.59	416.6	414.92	415.25	14848133.0
2021-05-20 16:00:00	SPY	ETF	415.24	415.43	414.79	415.06	3603150.0
2021-05-20 16:30:00	SPY	ETF	415.03	415.29	414.96	414.99	270588.0
2021-05-20 17:00:00	SPY	ETF	414.95	415.05	410.8845	414.99	139366.0
2021-05-20 17:30:00	SPY	ETF	414.98	414.99	414.9	414.96	46485.0
2021-05-20 18:00:00	SPY	ETF	414.95	415.27	414.88	415.18	100670.0
2021-05-20 18:30:00	SPY	ETF	415.28	415.4	415.19	415.3	158210.0
2021-05-20 19:00:00	SPY	ETF	415.28	415.43	415.23	415.4	11158.0
2021-05-20 19:30:00	SPY	ETF	415.4	415.85	415.4	415.83	38409.0
2021-05-20 04:00:00	QQQ	ETF	322.82	322.95	322.05	322.05	28646.0
2021-05-20 04:30:00	QQQ	ETF	322.17	322.24	321.23	321.46	43792.0
2021-05-20 05:00:00	QQQ	ETF	321.46	321.66	320.78	321.06	44818.0
2021-05-20 05:30:00	QQQ	ETF	320.99	321.21	320.75	321.19	22472.0
2021-05-20 06:00:00	QQQ	ETF	321.05	321.51	321.0	321.41	19807.0
2021-05-20 06:30:00	QQQ	ETF	321.48	321.75	321.27	321.73	23023.0
2021-05-20 07:00:00	QQQ	ETF	321.8	322.72	321.71	322.53	114197.0
2021-05-20 07:30:00	QQQ	ETF	322.56	322.86	322.42	322.61	84330.0
2021-05-20 08:00:00	QQQ	ETF	322.63	322.98	321.2996	322.77	143465.0
2021-05-20 08:30:00	QQQ	ETF	322.72	323.81	322.62	323.79	270973.0
2021-05-20 09:00:00	QQQ	ETF	323.9	324.28	323.79	324.11	286881.0
2021-05-20 09:30:00	QQQ	ETF	324.12	326.72	323.89	326.37	6058847.0
2021-05-20 10:00:00	QQQ	ETF	326.38	327.27	326.3	327.24	3097421.0
2021-05-20 10:30:00	QQQ	ETF	327.24	327.88	327.13	327.51	2845945.0
2021-05-20 11:00:00	QQQ	ETF	327.52	328.47	327.33	328.43	2171525.0
2021-05-20 11:30:00	QQQ	ETF	328.43	329.26	328.297	328.88	2521824.0
2021-05-20 12:00:00	QQQ	ETF	328.895	328.91	328.08	328.28	2799768.0
2021-05-20 12:30:00	QQQ	ETF	328.32	328.57	327.805	328.36	2225242.0

> showing 50 of 22,738 rows — these rows as CSV

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