PREVIEW / etf_30min / 2009-04-08

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-08.parquet
  size:    208 KB
  rows:    6,904

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
2009-04-08 04:00:00	SPY	ETF	80.95	80.95	80.92	80.95	5154.0
2009-04-08 04:30:00	SPY	ETF	81.05	81.15	81.05	81.15	600.0
2009-04-08 05:00:00	SPY	ETF	81.17	81.22	81.17	81.2	2400.0
2009-04-08 05:30:00	SPY	ETF	81.23	81.32	80.88	80.88	13770.0
2009-04-08 06:00:00	SPY	ETF	80.84	81.04	80.8	81.04	19147.0
2009-04-08 06:30:00	SPY	ETF	81.21	81.49	81.21	81.4	57900.0
2009-04-08 07:00:00	SPY	ETF	81.35	81.61	81.35	81.51	354980.0
2009-04-08 07:30:00	SPY	ETF	81.51	81.51	81.28	81.31	517700.0
2009-04-08 08:00:00	SPY	ETF	81.3	82.1	81.3	82.04	2755854.0
2009-04-08 08:30:00	SPY	ETF	82.02	82.26	81.26	82.13	1452569.0
2009-04-08 09:00:00	SPY	ETF	82.13	82.16	82.02	82.05	1173807.0
2009-04-08 09:30:00	SPY	ETF	82.06	82.6	82.02	82.24	22146065.0
2009-04-08 10:00:00	SPY	ETF	82.24	82.34	81.58	81.67	20233834.0
2009-04-08 10:30:00	SPY	ETF	81.66	81.94	81.54	81.93	19624530.0
2009-04-08 11:00:00	SPY	ETF	81.93	82.335	81.92	82.12	19558266.0
2009-04-08 11:30:00	SPY	ETF	82.12	82.54	82.07	82.29	16712795.0
2009-04-08 12:00:00	SPY	ETF	82.3	82.565	82.13	82.435	10339592.0
2009-04-08 12:30:00	SPY	ETF	82.44	82.94	82.34	82.8001	14670003.0
2009-04-08 13:00:00	SPY	ETF	82.81	82.83	82.59	82.71	8077977.0
2009-04-08 13:30:00	SPY	ETF	82.71	82.81	82.51	82.5975	9838549.0
2009-04-08 14:00:00	SPY	ETF	82.6	82.63	82.0	82.19	18588173.0
2009-04-08 14:30:00	SPY	ETF	82.2	82.32	81.84	82.01	16391717.0
2009-04-08 15:00:00	SPY	ETF	82.0	82.15	81.6	81.95	18038789.0
2009-04-08 15:30:00	SPY	ETF	81.95	82.61	81.935	82.54	22452164.0
2009-04-08 16:00:00	SPY	ETF	82.52	82.7	82.47	82.65	5131020.0
2009-04-08 16:30:00	SPY	ETF	82.65	82.87	82.2143	82.84	452831.0
2009-04-08 17:00:00	SPY	ETF	82.85	82.97	82.81	82.92	533219.0
2009-04-08 17:30:00	SPY	ETF	82.92	83.0	82.89	82.93	129107.0
2009-04-08 18:00:00	SPY	ETF	82.91	82.93	82.78	82.79	56509.0
2009-04-08 18:30:00	SPY	ETF	82.8	82.83	82.76	82.78	37693.0
2009-04-08 19:00:00	SPY	ETF	82.81	82.86	82.81	82.86	8583.0
2009-04-08 19:30:00	SPY	ETF	82.88	82.89	82.72	82.79	129414.0
2009-04-08 04:30:00	QQQ	ETF	31.31	31.34	31.31	31.34	1750.0
2009-04-08 05:00:00	QQQ	ETF	31.39	31.39	31.39	31.39	100.0
2009-04-08 05:30:00	QQQ	ETF	31.42	31.42	31.35	31.35	10995.0
2009-04-08 06:00:00	QQQ	ETF	31.27	31.41	31.27	31.41	21726.0
2009-04-08 06:30:00	QQQ	ETF	31.39	31.51	31.39	31.48	53720.0
2009-04-08 07:00:00	QQQ	ETF	31.49	31.56	31.49	31.52	251667.0
2009-04-08 07:30:00	QQQ	ETF	31.54	31.54	31.5	31.51	272594.0
2009-04-08 08:00:00	QQQ	ETF	31.52	31.79	31.51	31.77	641570.0
2009-04-08 08:30:00	QQQ	ETF	31.76	31.85	31.72	31.77	1082977.0
2009-04-08 09:00:00	QQQ	ETF	31.78	31.8	31.71	31.72	639975.0
2009-04-08 09:30:00	QQQ	ETF	31.72	31.965	31.68	31.89	15028899.0
2009-04-08 10:00:00	QQQ	ETF	31.9	31.91	31.49	31.56	17554242.0
2009-04-08 10:30:00	QQQ	ETF	31.56	31.62	31.49	31.61	11892886.0
2009-04-08 11:00:00	QQQ	ETF	31.6	31.87	31.6	31.81	7275467.0
2009-04-08 11:30:00	QQQ	ETF	31.81	31.93	31.76	31.84	7109613.0
2009-04-08 12:00:00	QQQ	ETF	31.8408	32.0	31.82	31.9405	4375029.0
2009-04-08 12:30:00	QQQ	ETF	31.94	32.15	31.88	32.08	7942148.0
2009-04-08 13:00:00	QQQ	ETF	32.08	32.09	31.97	32.01	4825949.0

> showing 50 of 6,904 rows — these rows as CSV

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