PREVIEW / etf_30min / 2021-05-11

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-11.parquet
  size:    638 KB
  rows:    24,940

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-11 04:00:00	SPY	ETF	416.0	416.0	414.16	414.71	40230.0
2021-05-11 04:30:00	SPY	ETF	414.61	415.05	414.6	414.85	37060.0
2021-05-11 05:00:00	SPY	ETF	414.99	415.7	414.99	415.13	13169.0
2021-05-11 05:30:00	SPY	ETF	415.19	415.45	415.0	415.19	40175.0
2021-05-11 06:00:00	SPY	ETF	415.19	415.22	414.5	414.7	17637.0
2021-05-11 06:30:00	SPY	ETF	414.69	414.89	414.22	414.82	112644.0
2021-05-11 07:00:00	SPY	ETF	414.82	414.97	414.4	414.64	105298.0
2021-05-11 07:30:00	SPY	ETF	414.56	414.75	414.0	414.07	143094.0
2021-05-11 08:00:00	SPY	ETF	414.82	416.0	412.55	412.58	583154.0
2021-05-11 08:30:00	SPY	ETF	412.6	413.16	412.41	412.55	458995.0
2021-05-11 09:00:00	SPY	ETF	412.5	413.2	412.04	413.1	1020763.0
2021-05-11 09:30:00	SPY	ETF	413.1	414.89	412.26	414.8822	13319046.0
2021-05-11 10:00:00	SPY	ETF	414.9	415.27	411.81	411.85	10681813.0
2021-05-11 10:30:00	SPY	ETF	411.86	412.37	410.06	411.83	10628416.0
2021-05-11 11:00:00	SPY	ETF	411.82	413.9	410.77	413.88	7039944.0
2021-05-11 11:30:00	SPY	ETF	413.87	414.36	413.11	414.03	5287550.0
2021-05-11 12:00:00	SPY	ETF	414.03	414.45	413.32	413.43	3677469.0
2021-05-11 12:30:00	SPY	ETF	413.435	413.73	412.043	412.5375	3801927.0
2021-05-11 13:00:00	SPY	ETF	412.52	414.19	412.355	414.145	4962270.0
2021-05-11 13:30:00	SPY	ETF	414.1419	414.735	413.59	414.2257	3778580.0
2021-05-11 14:00:00	SPY	ETF	414.23	414.78	413.21	414.73	4245389.0
2021-05-11 14:30:00	SPY	ETF	414.72	414.72	413.14	414.1	4949883.0
2021-05-11 15:00:00	SPY	ETF	414.09	415.03	413.39	414.45	5435675.0
2021-05-11 15:30:00	SPY	ETF	414.45	414.59	412.66	414.27	14296136.0
2021-05-11 16:00:00	SPY	ETF	414.27	414.69	413.54	413.62	3114596.0
2021-05-11 16:30:00	SPY	ETF	413.6	413.72	413.39	413.69	187649.0
2021-05-11 17:00:00	SPY	ETF	413.64	413.72	413.45	413.51	49307.0
2021-05-11 17:30:00	SPY	ETF	413.56	413.7	413.5	413.64	52594.0
2021-05-11 18:00:00	SPY	ETF	413.64	413.89	413.46	413.87	61024.0
2021-05-11 18:30:00	SPY	ETF	414.21	414.21	413.61	413.75	9705.0
2021-05-11 19:00:00	SPY	ETF	413.7	413.79	413.37	413.79	26097.0
2021-05-11 19:30:00	SPY	ETF	413.69	414.3	413.69	414.25	50521.0
2021-05-11 04:00:00	QQQ	ETF	321.8	321.99	320.72	321.21	82740.0
2021-05-11 04:30:00	QQQ	ETF	321.2	322.0	321.11	321.56	43469.0
2021-05-11 05:00:00	QQQ	ETF	321.51	322.04	321.43	321.59	36798.0
2021-05-11 05:30:00	QQQ	ETF	321.6	321.94	321.23	321.54	39557.0
2021-05-11 06:00:00	QQQ	ETF	321.68	321.68	321.13	321.5	45990.0
2021-05-11 06:30:00	QQQ	ETF	321.52	321.59	320.86	321.44	50322.0
2021-05-11 07:00:00	QQQ	ETF	321.47	321.58	320.74	321.07	356732.0
2021-05-11 07:30:00	QQQ	ETF	321.03	321.19	319.85	319.9	349814.0
2021-05-11 08:00:00	QQQ	ETF	319.9	323.45	319.15	319.25	752859.0
2021-05-11 08:30:00	QQQ	ETF	319.26	319.53	318.92	319.03	780642.0
2021-05-11 09:00:00	QQQ	ETF	319.03	319.78	318.57	319.68	804369.0
2021-05-11 09:30:00	QQQ	ETF	319.7	323.59	319.02	323.58	9875425.0
2021-05-11 10:00:00	QQQ	ETF	323.6	323.77	320.99	321.09	7017403.0
2021-05-11 10:30:00	QQQ	ETF	321.09	322.66	320.06	322.16	5761081.0
2021-05-11 11:00:00	QQQ	ETF	322.14	324.59	321.02	324.51	4536702.0
2021-05-11 11:30:00	QQQ	ETF	324.51	324.91	323.65	324.44	4070832.0
2021-05-11 12:00:00	QQQ	ETF	324.44	325.24	324.06	324.2	2572297.0
2021-05-11 12:30:00	QQQ	ETF	324.22	324.61	323.01	323.6299	2349742.0

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

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