PREVIEW / etf_30min / 2008-06-04

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-04.parquet
  size:    169 KB
  rows:    5,795

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-04 04:00:00	SPY	ETF	137.86	137.88	137.6	137.6	4900.0
2008-06-04 04:30:00	SPY	ETF	137.71	137.71	137.66	137.66	1000.0
2008-06-04 05:00:00	SPY	ETF	137.71	137.71	137.6	137.64	1500.0
2008-06-04 05:30:00	SPY	ETF	137.57	137.57	137.5	137.5	75100.0
2008-06-04 06:00:00	SPY	ETF	137.64	137.64	137.64	137.64	1600.0
2008-06-04 06:30:00	SPY	ETF	137.59	137.68	137.56	137.68	163000.0
2008-06-04 07:00:00	SPY	ETF	137.63	137.65	137.47	137.59	108969.0
2008-06-04 07:30:00	SPY	ETF	137.6	137.61	137.45	137.53	288217.0
2008-06-04 08:00:00	SPY	ETF	137.56	137.93	137.46	137.71	3111341.0
2008-06-04 08:30:00	SPY	ETF	137.71	137.89	137.55	137.55	2501632.0
2008-06-04 09:00:00	SPY	ETF	137.55	137.81	137.46	137.76	1511858.0
2008-06-04 09:30:00	SPY	ETF	137.77	138.46	137.7	138.19	26161179.0
2008-06-04 10:00:00	SPY	ETF	138.18	138.49	137.97	138.43	18034843.0
2008-06-04 10:30:00	SPY	ETF	138.43	138.86	138.2	138.76	16645805.0
2008-06-04 11:00:00	SPY	ETF	138.75	139.08	138.6	138.97	11093767.0
2008-06-04 11:30:00	SPY	ETF	138.96	139.0	138.67	138.79	7452283.0
2008-06-04 12:00:00	SPY	ETF	138.79	139.16	138.69	138.961	8913918.0
2008-06-04 12:30:00	SPY	ETF	138.98	139.13	138.47	138.52	17495952.0
2008-06-04 13:00:00	SPY	ETF	138.52	138.79	138.25	138.71	16176453.0
2008-06-04 13:30:00	SPY	ETF	138.72	138.93	138.59	138.83	7286357.0
2008-06-04 14:00:00	SPY	ETF	138.83	138.89	138.05	138.12	17035499.0
2008-06-04 14:30:00	SPY	ETF	138.12	138.5	137.46	137.59	35150188.0
2008-06-04 15:00:00	SPY	ETF	137.59	138.48	137.49	137.88	25344976.0
2008-06-04 15:30:00	SPY	ETF	137.87	138.33	137.69	138.04	20852369.0
2008-06-04 16:00:00	SPY	ETF	138.0199	139.25	137.95	138.02	2059484.0
2008-06-04 16:30:00	SPY	ETF	138.03	138.12	137.9	138.02	3121764.0
2008-06-04 17:00:00	SPY	ETF	138.02	138.05	137.97	137.99	10806.0
2008-06-04 17:30:00	SPY	ETF	138.0	138.06	137.99	138.05	26000.0
2008-06-04 18:00:00	SPY	ETF	138.05	138.1	138.02	138.1	59392.0
2008-06-04 18:30:00	SPY	ETF	138.12	138.12	138.04	138.05	4750.0
2008-06-04 19:00:00	SPY	ETF	138.08	138.08	138.02	138.06	2400.0
2008-06-04 19:30:00	SPY	ETF	138.05	138.15	138.05	138.15	1400.0
2008-06-04 04:00:00	QQQ	ETF	49.0	49.0	49.0	49.0	300.0
2008-06-04 05:30:00	QQQ	ETF	49.02	49.02	49.02	49.02	200.0
2008-06-04 06:00:00	QQQ	ETF	49.02	49.02	49.02	49.02	500.0
2008-06-04 06:30:00	QQQ	ETF	48.98	49.02	48.98	49.02	700.0
2008-06-04 07:00:00	QQQ	ETF	49.05	49.05	48.92	48.95	82769.0
2008-06-04 07:30:00	QQQ	ETF	48.95	48.99	48.95	48.96	82391.0
2008-06-04 08:00:00	QQQ	ETF	48.98	49.1	48.89	48.92	688678.0
2008-06-04 08:30:00	QQQ	ETF	48.92	49.0	48.85	48.87	693641.0
2008-06-04 09:00:00	QQQ	ETF	48.88	48.98	48.84	48.96	913699.0
2008-06-04 09:30:00	QQQ	ETF	48.97	49.44	48.94	49.33	17797534.0
2008-06-04 10:00:00	QQQ	ETF	49.325	49.61	49.24	49.57	13271121.0
2008-06-04 10:30:00	QQQ	ETF	49.57	49.93	49.47	49.87	18779952.0
2008-06-04 11:00:00	QQQ	ETF	49.88	50.06	49.86	49.95	9857409.0
2008-06-04 11:30:00	QQQ	ETF	49.96	50.0	49.9	49.909	7621466.0
2008-06-04 12:00:00	QQQ	ETF	49.9	50.1	49.86	50.0	8125773.0
2008-06-04 12:30:00	QQQ	ETF	50.01	50.06	49.82	49.83	9392348.0
2008-06-04 13:00:00	QQQ	ETF	49.83	49.92	49.7	49.89	9781546.0
2008-06-04 13:30:00	QQQ	ETF	49.88	50.0	49.855	49.98	5785579.0

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

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