PREVIEW / etf_30min / 2007-08-30

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-30.parquet
  size:    122 KB
  rows:    4,471

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
2007-08-30 04:30:00	SPY	ETF	146.34	146.44	146.34	146.44	2500.0
2007-08-30 05:30:00	SPY	ETF	146.12	146.12	145.87	145.87	1500.0
2007-08-30 06:00:00	SPY	ETF	145.86	145.88	145.8	145.8	5500.0
2007-08-30 06:30:00	SPY	ETF	145.81	145.88	145.6	145.61	308200.0
2007-08-30 07:00:00	SPY	ETF	145.66	145.95	145.6	145.77	704200.0
2007-08-30 07:30:00	SPY	ETF	145.76	145.98	145.7	145.95	337000.0
2007-08-30 08:00:00	SPY	ETF	146.0	146.06	145.73	145.75	2166500.0
2007-08-30 08:30:00	SPY	ETF	145.77	146.12	145.7	145.84	2586100.0
2007-08-30 09:00:00	SPY	ETF	145.84	146.3	145.41	145.45	3392500.0
2007-08-30 09:30:00	SPY	ETF	145.45	146.34	145.31	146.05	29233006.0
2007-08-30 10:00:00	SPY	ETF	146.051	146.51	145.87	146.37	17031600.0
2007-08-30 10:30:00	SPY	ETF	146.36	146.55	146.1	146.3705	10271900.0
2007-08-30 11:00:00	SPY	ETF	146.37	147.16	146.34	146.99	17801900.0
2007-08-30 11:30:00	SPY	ETF	146.99	147.19	146.81	146.87	8734000.0
2007-08-30 12:00:00	SPY	ETF	146.865	146.871	145.86	146.36	21549600.0
2007-08-30 12:30:00	SPY	ETF	146.36	147.0	146.23	146.86	9023500.0
2007-08-30 13:00:00	SPY	ETF	146.858	146.99	146.45	146.57	7067300.0
2007-08-30 13:30:00	SPY	ETF	146.58	146.65	146.16	146.62	6355300.0
2007-08-30 14:00:00	SPY	ETF	146.62	146.72	146.14	146.15	6284200.0
2007-08-30 14:30:00	SPY	ETF	146.15	146.23	145.54	145.67	13545700.0
2007-08-30 15:00:00	SPY	ETF	145.67	146.5	145.64	146.2	12352800.0
2007-08-30 15:30:00	SPY	ETF	146.2	146.35	145.81	146.14	15450000.0
2007-08-30 16:00:00	SPY	ETF	146.11	146.7	145.95	146.17	4605000.0
2007-08-30 16:30:00	SPY	ETF	146.22	146.41	146.0583	146.41	379900.0
2007-08-30 17:00:00	SPY	ETF	146.35	146.5	146.34	146.5	131200.0
2007-08-30 17:30:00	SPY	ETF	146.5	146.58	146.48	146.5	42100.0
2007-08-30 18:00:00	SPY	ETF	146.5	146.52	146.32	146.32	42600.0
2007-08-30 18:30:00	SPY	ETF	146.15	146.39	146.15	146.39	301400.0
2007-08-30 19:00:00	SPY	ETF	146.37	146.37	146.31	146.31	19600.0
2007-08-30 19:30:00	SPY	ETF	146.3	146.31	146.23	146.26	115300.0
2007-08-30 04:30:00	QQQ	ETF	48.11	48.11	48.11	48.11	1000.0
2007-08-30 05:00:00	QQQ	ETF	48.09	48.09	48.09	48.09	300.0
2007-08-30 06:00:00	QQQ	ETF	47.98	48.0	47.96	48.0	10600.0
2007-08-30 06:30:00	QQQ	ETF	47.98	47.98	47.91	47.91	16100.0
2007-08-30 07:00:00	QQQ	ETF	47.95	48.05	47.93	48.0	446548.0
2007-08-30 07:30:00	QQQ	ETF	47.99	48.05	47.91	48.02	545237.0
2007-08-30 08:00:00	QQQ	ETF	48.01	48.07	47.92	47.94	2291030.0
2007-08-30 08:30:00	QQQ	ETF	47.92	48.04	47.92	47.95	1184231.0
2007-08-30 09:00:00	QQQ	ETF	47.94	47.94	47.8	47.83	958670.0
2007-08-30 09:30:00	QQQ	ETF	47.83	48.27	47.75	48.18	12842274.0
2007-08-30 10:00:00	QQQ	ETF	48.18	48.58	48.14	48.5	20041973.0
2007-08-30 10:30:00	QQQ	ETF	48.5	48.57	48.4	48.49	5080006.0
2007-08-30 11:00:00	QQQ	ETF	48.49	48.74	48.4801	48.64	8404782.0
2007-08-30 11:30:00	QQQ	ETF	48.64	48.74	48.58	48.62	7470382.0
2007-08-30 12:00:00	QQQ	ETF	48.61	48.6199	48.32	48.5	13033519.0
2007-08-30 12:30:00	QQQ	ETF	48.5	48.66	48.45	48.61	5514921.0
2007-08-30 13:00:00	QQQ	ETF	48.61	48.65	48.44	48.47	3103605.0
2007-08-30 13:30:00	QQQ	ETF	48.48	48.55	48.3914	48.54	5327773.0
2007-08-30 14:00:00	QQQ	ETF	48.55	48.58	48.29	48.2921	5170365.0
2007-08-30 14:30:00	QQQ	ETF	48.29	48.31	48.03	48.1	9693761.0

> showing 50 of 4,471 rows — these rows as CSV

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