PREVIEW / etf_30min / 2021-05-12

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-12.parquet
  size:    647 KB
  rows:    25,121

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-12 04:00:00	SPY	ETF	414.0	414.25	413.13	413.2	6272.0
2021-05-12 04:30:00	SPY	ETF	413.19	413.33	412.8	412.94	6414.0
2021-05-12 05:00:00	SPY	ETF	413.09	413.49	412.99	413.42	3200.0
2021-05-12 05:30:00	SPY	ETF	413.16	413.16	412.54	412.87	3249.0
2021-05-12 06:00:00	SPY	ETF	412.95	413.6	412.81	413.25	22928.0
2021-05-12 06:30:00	SPY	ETF	413.26	413.53	412.35	412.53	48575.0
2021-05-12 07:00:00	SPY	ETF	412.53	412.92	412.25	412.57	94735.0
2021-05-12 07:30:00	SPY	ETF	412.59	413.06	412.59	413.06	58440.0
2021-05-12 08:00:00	SPY	ETF	412.4899	414.22	411.3	412.79	211313.0
2021-05-12 08:30:00	SPY	ETF	412.76	412.76	409.29	411.61	1441815.0
2021-05-12 09:00:00	SPY	ETF	411.67	412.28	410.91	411.27	563676.0
2021-05-12 09:30:00	SPY	ETF	411.23	412.59	410.94	411.13	9255057.0
2021-05-12 10:00:00	SPY	ETF	411.12	411.52	410.34	410.3502	7046962.0
2021-05-12 10:30:00	SPY	ETF	410.37	410.73	408.74	409.43	8373441.0
2021-05-12 11:00:00	SPY	ETF	409.43	410.14	409.17	409.56	4611440.0
2021-05-12 11:30:00	SPY	ETF	409.54	409.78	407.565	407.79	5705713.0
2021-05-12 12:00:00	SPY	ETF	407.8	408.18	406.72	407.725	6178755.0
2021-05-12 12:30:00	SPY	ETF	407.7	408.07	407.01	407.77	4719234.0
2021-05-12 13:00:00	SPY	ETF	407.75	408.61	407.3	407.4989	5353139.0
2021-05-12 13:30:00	SPY	ETF	407.5	407.89	406.86	407.28	4534197.0
2021-05-12 14:00:00	SPY	ETF	407.27	407.66	406.42	406.73	4841118.0
2021-05-12 14:30:00	SPY	ETF	406.71	408.25	406.32	407.47	5362250.0
2021-05-12 15:00:00	SPY	ETF	407.44	407.6	405.4	405.7299	8037942.0
2021-05-12 15:30:00	SPY	ETF	405.7299	406.57	404.0	405.44	24621232.0
2021-05-12 16:00:00	SPY	ETF	405.44	406.2135	405.0	405.3	5187501.0
2021-05-12 16:30:00	SPY	ETF	405.3	405.44	404.81	404.92	263167.0
2021-05-12 17:00:00	SPY	ETF	404.99	405.41	404.8	404.99	336584.0
2021-05-12 17:30:00	SPY	ETF	405.03	405.14	404.76	405.05	95854.0
2021-05-12 18:00:00	SPY	ETF	405.15	406.1	405.15	405.69	172390.0
2021-05-12 18:30:00	SPY	ETF	405.41	406.05	405.41	405.92	38624.0
2021-05-12 19:00:00	SPY	ETF	405.95	406.25	405.81	406.01	24728.0
2021-05-12 19:30:00	SPY	ETF	406.0	406.2	405.8	406.14	46358.0
2021-05-12 04:00:00	QQQ	ETF	324.79	324.99	323.92	324.03	15671.0
2021-05-12 04:30:00	QQQ	ETF	323.99	324.1	323.51	323.7	10184.0
2021-05-12 05:00:00	QQQ	ETF	323.76	324.29	323.6	323.93	18064.0
2021-05-12 05:30:00	QQQ	ETF	324.02	324.04	323.15	323.71	39004.0
2021-05-12 06:00:00	QQQ	ETF	323.52	324.16	323.47	323.86	30154.0
2021-05-12 06:30:00	QQQ	ETF	324.04	324.29	323.1	323.12	126231.0
2021-05-12 07:00:00	QQQ	ETF	323.3	323.83	323.129	323.37	144613.0
2021-05-12 07:30:00	QQQ	ETF	323.35	323.68	323.22	323.61	81291.0
2021-05-12 08:00:00	QQQ	ETF	323.22	324.38	321.62	323.51	265132.0
2021-05-12 08:30:00	QQQ	ETF	323.43	323.43	319.11	320.84	2581109.0
2021-05-12 09:00:00	QQQ	ETF	320.85	322.22	320.02	320.22	1405093.0
2021-05-12 09:30:00	QQQ	ETF	320.23	322.62	319.97	320.82	8435797.0
2021-05-12 10:00:00	QQQ	ETF	320.81	320.96	319.5	319.58	5901810.0
2021-05-12 10:30:00	QQQ	ETF	319.59	319.96	317.88	318.4728	5935141.0
2021-05-12 11:00:00	QQQ	ETF	318.46	319.65	318.19	318.72	3253026.0
2021-05-12 11:30:00	QQQ	ETF	318.72	318.8	317.19	317.32	3818873.0
2021-05-12 12:00:00	QQQ	ETF	317.33	318.05	316.5	317.53	4489113.0
2021-05-12 12:30:00	QQQ	ETF	317.52	318.27	317.005	318.17	3978590.0

> showing 50 of 25,121 rows — these rows as CSV

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