PREVIEW / etf_30min / 2008-05-12

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-12.parquet
  size:    159 KB
  rows:    5,488

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-12 04:00:00	SPY	ETF	139.41	139.41	139.41	139.41	200.0
2008-05-12 06:30:00	SPY	ETF	139.25	139.34	139.16	139.34	11500.0
2008-05-12 07:00:00	SPY	ETF	139.3	139.42	139.3	139.39	147800.0
2008-05-12 07:30:00	SPY	ETF	139.38	139.54	139.34	139.34	185307.0
2008-05-12 08:00:00	SPY	ETF	139.34	139.36	139.18	139.2	972739.0
2008-05-12 08:30:00	SPY	ETF	139.2	139.22	139.06	139.18	372775.0
2008-05-12 09:00:00	SPY	ETF	139.18	139.4	139.1	139.24	788879.0
2008-05-12 09:30:00	SPY	ETF	139.25	139.38	138.925	139.01	13695231.0
2008-05-12 10:00:00	SPY	ETF	139.01	139.06	138.73	139.01	13507649.0
2008-05-12 10:30:00	SPY	ETF	139.01	139.66	138.95	139.54	15239862.0
2008-05-12 11:00:00	SPY	ETF	139.54	139.75	139.43	139.67	8876334.0
2008-05-12 11:30:00	SPY	ETF	139.66	139.89	139.56	139.86	9091771.0
2008-05-12 12:00:00	SPY	ETF	139.87	140.02	139.76	139.88	7907536.0
2008-05-12 12:30:00	SPY	ETF	139.87	140.13	139.8	139.93	8015461.0
2008-05-12 13:00:00	SPY	ETF	139.94	139.95	139.67	139.72	8433077.0
2008-05-12 13:30:00	SPY	ETF	139.72	139.78	139.58	139.76	6930627.0
2008-05-12 14:00:00	SPY	ETF	139.77	140.25	139.69	140.21	9793619.0
2008-05-12 14:30:00	SPY	ETF	140.2	140.53	140.19	140.38	9558689.0
2008-05-12 15:00:00	SPY	ETF	140.38	140.51	140.19	140.31	11820445.0
2008-05-12 15:30:00	SPY	ETF	140.31	140.48	140.17	140.47	13682417.0
2008-05-12 16:00:00	SPY	ETF	140.47	140.57	140.4	140.46	4168248.0
2008-05-12 16:30:00	SPY	ETF	140.47	140.51	140.42	140.49	231286.0
2008-05-12 17:00:00	SPY	ETF	140.49	140.52	138.93	140.47	2180113.0
2008-05-12 17:30:00	SPY	ETF	140.4	140.5	140.4	140.42	2007375.0
2008-05-12 18:00:00	SPY	ETF	140.46	140.47	140.41	140.46	1008100.0
2008-05-12 19:00:00	SPY	ETF	140.49	140.51	140.48	140.48	16247.0
2008-05-12 19:30:00	SPY	ETF	140.55	140.6	140.53	140.57	13900.0
2008-05-12 04:00:00	QQQ	ETF	48.34	48.34	48.34	48.34	200.0
2008-05-12 06:00:00	QQQ	ETF	48.25	48.25	48.25	48.25	400.0
2008-05-12 06:30:00	QQQ	ETF	48.27	48.27	48.27	48.27	100.0
2008-05-12 07:00:00	QQQ	ETF	48.31	48.31	48.29	48.3	7200.0
2008-05-12 07:30:00	QQQ	ETF	48.31	48.37	48.3	48.3	28684.0
2008-05-12 08:00:00	QQQ	ETF	48.31	48.31	48.23	48.28	128384.0
2008-05-12 08:30:00	QQQ	ETF	48.27	48.28	48.21	48.25	216299.0
2008-05-12 09:00:00	QQQ	ETF	48.26	48.32	48.24	48.27	520853.0
2008-05-12 09:30:00	QQQ	ETF	48.28	48.38	48.23	48.31	8950824.0
2008-05-12 10:00:00	QQQ	ETF	48.31	48.37	48.2	48.35	6732526.0
2008-05-12 10:30:00	QQQ	ETF	48.35	48.64	48.29	48.57	9196683.0
2008-05-12 11:00:00	QQQ	ETF	48.58	48.65	48.51	48.5901	4809472.0
2008-05-12 11:30:00	QQQ	ETF	48.6	48.81	48.58	48.79	5404528.0
2008-05-12 12:00:00	QQQ	ETF	48.79	48.86	48.77	48.82	3590133.0
2008-05-12 12:30:00	QQQ	ETF	48.82	48.92	48.75	48.88	3298903.0
2008-05-12 13:00:00	QQQ	ETF	48.88	48.89	48.75	48.76	4061944.0
2008-05-12 13:30:00	QQQ	ETF	48.7517	48.8	48.7	48.8	3764283.0
2008-05-12 14:00:00	QQQ	ETF	48.8	49.02	48.78	49.0	4295828.0
2008-05-12 14:30:00	QQQ	ETF	49.01	49.19	48.99	49.09	6708594.0
2008-05-12 15:00:00	QQQ	ETF	49.1	49.16	49.03	49.07	8925384.0
2008-05-12 15:30:00	QQQ	ETF	49.07	49.13	49.04	49.1	9945437.0
2008-05-12 16:00:00	QQQ	ETF	49.1001	49.15	48.7545	49.08	6978877.0
2008-05-12 16:30:00	QQQ	ETF	49.07	49.09	49.04	49.08	464459.0

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

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