PREVIEW / etf_30min / 2008-06-30

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-30.parquet
  size:    171 KB
  rows:    5,983

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-06-30 04:00:00	SPY	ETF	127.93	127.93	127.78	127.78	3000.0
2008-06-30 04:30:00	SPY	ETF	127.5	127.5	127.33	127.33	400.0
2008-06-30 05:00:00	SPY	ETF	127.47	127.47	127.47	127.47	500.0
2008-06-30 05:30:00	SPY	ETF	127.56	127.66	127.56	127.66	2000.0
2008-06-30 06:00:00	SPY	ETF	127.87	127.87	127.69	127.69	1100.0
2008-06-30 06:30:00	SPY	ETF	127.49	127.79	127.48	127.62	65700.0
2008-06-30 07:00:00	SPY	ETF	127.73	127.85	127.6	127.8	616100.0
2008-06-30 07:30:00	SPY	ETF	127.8	127.81	127.37	127.37	333626.0
2008-06-30 08:00:00	SPY	ETF	127.38	127.95	127.38	127.85	2653542.0
2008-06-30 08:30:00	SPY	ETF	127.86	127.96	127.73	127.94	1168134.0
2008-06-30 09:00:00	SPY	ETF	127.94	127.96	127.74	127.89	1401571.0
2008-06-30 09:30:00	SPY	ETF	127.89	128.33	127.56	127.58	24962985.0
2008-06-30 10:00:00	SPY	ETF	127.59	128.2	127.3	128.13	26066798.0
2008-06-30 10:30:00	SPY	ETF	128.12	128.57	127.8	128.54	19958940.0
2008-06-30 11:00:00	SPY	ETF	128.55	128.87	128.27	128.83	24624018.0
2008-06-30 11:30:00	SPY	ETF	128.83	128.86	128.37	128.6	14293031.0
2008-06-30 12:00:00	SPY	ETF	128.61	128.86	128.45	128.79	11282286.0
2008-06-30 12:30:00	SPY	ETF	128.79	128.91	128.53	128.5801	9704169.0
2008-06-30 13:00:00	SPY	ETF	128.5801	128.69	128.4	128.41	13330238.0
2008-06-30 13:30:00	SPY	ETF	128.42	128.47	127.88	128.13	23136717.0
2008-06-30 14:00:00	SPY	ETF	128.12	128.47	128.0	128.39	13592359.0
2008-06-30 14:30:00	SPY	ETF	128.39	128.41	128.06	128.23	14241735.0
2008-06-30 15:00:00	SPY	ETF	128.23	128.63	128.23	128.53	12956082.0
2008-06-30 15:30:00	SPY	ETF	128.53	128.63	127.68	127.84	29747060.0
2008-06-30 16:00:00	SPY	ETF	127.74	128.6616	127.68	128.05	4842146.0
2008-06-30 16:30:00	SPY	ETF	128.04	128.24	128.04	128.22	420737.0
2008-06-30 17:00:00	SPY	ETF	128.2	128.23	128.06	128.11	265766.0
2008-06-30 17:30:00	SPY	ETF	128.11	128.17	128.03	128.1	216994.0
2008-06-30 18:00:00	SPY	ETF	128.1	128.15	127.99	128.08	76730.0
2008-06-30 18:30:00	SPY	ETF	128.08	128.1	128.06	128.06	13420.0
2008-06-30 19:00:00	SPY	ETF	128.06	128.11	128.06	128.11	1200.0
2008-06-30 19:30:00	SPY	ETF	128.18	128.25	128.11	128.25	24600.0
2008-06-30 04:30:00	QQQ	ETF	45.52	45.52	45.52	45.52	200.0
2008-06-30 05:30:00	QQQ	ETF	45.45	45.45	45.45	45.45	2000.0
2008-06-30 06:00:00	QQQ	ETF	45.56	45.61	45.56	45.61	400.0
2008-06-30 06:30:00	QQQ	ETF	45.48	45.53	45.45	45.5	34000.0
2008-06-30 07:00:00	QQQ	ETF	45.53	45.6	45.53	45.57	228807.0
2008-06-30 07:30:00	QQQ	ETF	45.59	45.59	45.35	45.37	490474.0
2008-06-30 08:00:00	QQQ	ETF	45.38	45.58	45.36	45.55	1668399.0
2008-06-30 08:30:00	QQQ	ETF	45.56	45.65	45.54	45.64	1642944.0
2008-06-30 09:00:00	QQQ	ETF	45.64	45.65	45.53	45.53	1379238.0
2008-06-30 09:30:00	QQQ	ETF	45.53	45.76	45.37	45.38	5871046.0
2008-06-30 10:00:00	QQQ	ETF	45.39	45.62	45.24	45.58	10195064.0
2008-06-30 10:30:00	QQQ	ETF	45.57	45.67	45.38	45.66	9620754.0
2008-06-30 11:00:00	QQQ	ETF	45.66	45.83	45.58	45.8199	8758023.0
2008-06-30 11:30:00	QQQ	ETF	45.8199	45.83	45.55	45.65	6274409.0
2008-06-30 12:00:00	QQQ	ETF	45.65	45.74	45.56	45.73	6262778.0
2008-06-30 12:30:00	QQQ	ETF	45.73	45.74	45.48	45.53	6663780.0
2008-06-30 13:00:00	QQQ	ETF	45.52	45.61	45.43	45.47	5237972.0
2008-06-30 13:30:00	QQQ	ETF	45.47	45.51	45.19	45.26	9468563.0

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

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