PREVIEW / etf_30min / 2008-05-08

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-08.parquet
  size:    161 KB
  rows:    5,586

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
2008-05-08 04:00:00	SPY	ETF	139.87	139.87	139.87	139.87	100.0
2008-05-08 05:00:00	SPY	ETF	139.97	139.97	139.97	139.97	5000.0
2008-05-08 05:30:00	SPY	ETF	139.98	139.98	139.91	139.91	2100.0
2008-05-08 06:00:00	SPY	ETF	139.9	139.93	139.9	139.93	5000.0
2008-05-08 06:30:00	SPY	ETF	139.9	140.09	139.9	140.06	88800.0
2008-05-08 07:00:00	SPY	ETF	140.05	140.09	139.92	140.04	232100.0
2008-05-08 07:30:00	SPY	ETF	140.09	140.18	139.99	140.02	365398.0
2008-05-08 08:00:00	SPY	ETF	140.12	140.12	139.85	140.02	1849385.0
2008-05-08 08:30:00	SPY	ETF	140.04	140.22	139.69	139.76	1609830.0
2008-05-08 09:00:00	SPY	ETF	139.77	139.9	139.73	139.74	1012909.0
2008-05-08 09:30:00	SPY	ETF	139.74	140.02	139.45	139.73	16018266.0
2008-05-08 10:00:00	SPY	ETF	139.73	139.73	139.25	139.56	16042409.0
2008-05-08 10:30:00	SPY	ETF	139.56	139.67	138.98	139.36	16463164.0
2008-05-08 11:00:00	SPY	ETF	139.36	139.95	139.26	139.84	19948535.0
2008-05-08 11:30:00	SPY	ETF	139.83	139.95	139.56	139.7	8833708.0
2008-05-08 12:00:00	SPY	ETF	139.7	139.8	139.39	139.42	10079847.0
2008-05-08 12:30:00	SPY	ETF	139.41	139.61	139.31	139.6	4726208.0
2008-05-08 13:00:00	SPY	ETF	139.6	140.07	139.31	140.0	10984560.0
2008-05-08 13:30:00	SPY	ETF	140.0	140.32	139.83	140.29	13711383.0
2008-05-08 14:00:00	SPY	ETF	140.29	140.3	139.68	139.73	10330203.0
2008-05-08 14:30:00	SPY	ETF	139.73	139.94	139.45	139.54	9572618.0
2008-05-08 15:00:00	SPY	ETF	139.53	140.0	139.24	139.51	14103129.0
2008-05-08 15:30:00	SPY	ETF	139.51	139.87	139.44	139.84	11314433.0
2008-05-08 16:00:00	SPY	ETF	139.869	140.35	139.14	139.22	4082815.0
2008-05-08 16:30:00	SPY	ETF	139.22	139.385	138.98	138.99	3087384.0
2008-05-08 17:00:00	SPY	ETF	138.98	139.16	138.98	139.06	1835829.0
2008-05-08 17:30:00	SPY	ETF	139.14	139.15	139.07	139.1	12900.0
2008-05-08 18:00:00	SPY	ETF	139.07	139.09	138.97	138.99	38908.0
2008-05-08 18:30:00	SPY	ETF	139.0	139.13	139.0	139.13	1063.0
2008-05-08 19:00:00	SPY	ETF	139.1	139.19	139.1	139.17	13200.0
2008-05-08 19:30:00	SPY	ETF	139.19	139.22	139.15	139.22	6447.0
2008-05-08 06:30:00	QQQ	ETF	48.25	48.3	48.25	48.3	1100.0
2008-05-08 07:00:00	QQQ	ETF	48.23	48.26	48.22	48.24	61416.0
2008-05-08 07:30:00	QQQ	ETF	48.23	48.28	48.23	48.26	191841.0
2008-05-08 08:00:00	QQQ	ETF	48.25	48.28	48.24	48.26	184347.0
2008-05-08 08:30:00	QQQ	ETF	48.27	48.29	48.2	48.22	651477.0
2008-05-08 09:00:00	QQQ	ETF	48.22	48.27	48.2	48.23	513495.0
2008-05-08 09:30:00	QQQ	ETF	48.24	48.37	48.13	48.249	14978338.0
2008-05-08 10:00:00	QQQ	ETF	48.25	48.29	48.06	48.28	12543789.0
2008-05-08 10:30:00	QQQ	ETF	48.28	48.33	48.085	48.29	11536111.0
2008-05-08 11:00:00	QQQ	ETF	48.29	48.58	48.27	48.51	12525673.0
2008-05-08 11:30:00	QQQ	ETF	48.52	48.538	48.35	48.44	7038563.0
2008-05-08 12:00:00	QQQ	ETF	48.44	48.5	48.29	48.31	4379543.0
2008-05-08 12:30:00	QQQ	ETF	48.3	48.4	48.22	48.35	4748367.0
2008-05-08 13:00:00	QQQ	ETF	48.35	48.56	48.15	48.5	5856441.0
2008-05-08 13:30:00	QQQ	ETF	48.51	48.7	48.47	48.69	5910937.0
2008-05-08 14:00:00	QQQ	ETF	48.68	48.69	48.38	48.38	6752085.0
2008-05-08 14:30:00	QQQ	ETF	48.38	48.47	48.22	48.31	8320343.0
2008-05-08 15:00:00	QQQ	ETF	48.31	48.42	48.17	48.268	8768643.0
2008-05-08 15:30:00	QQQ	ETF	48.26	48.42	48.25	48.41	10098354.0

> showing 50 of 5,586 rows — these rows as CSV

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