PREVIEW / etf_30min / 2008-07-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-18.parquet
  size:    172 KB
  rows:    5,894

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-07-18 04:30:00	SPY	ETF	124.75	124.75	124.75	124.75	500.0
2008-07-18 05:00:00	SPY	ETF	124.37	124.37	124.37	124.37	500.0
2008-07-18 05:30:00	SPY	ETF	124.57	124.6	124.5	124.5	25000.0
2008-07-18 06:00:00	SPY	ETF	124.68	124.74	124.62	124.74	10000.0
2008-07-18 06:30:00	SPY	ETF	125.04	125.79	125.01	125.63	787800.0
2008-07-18 07:00:00	SPY	ETF	125.58	125.95	125.52	125.85	2039599.0
2008-07-18 07:30:00	SPY	ETF	125.85	126.08	125.75	125.87	1795489.0
2008-07-18 08:00:00	SPY	ETF	125.86	126.17	125.26	126.16	2942266.0
2008-07-18 08:30:00	SPY	ETF	126.15	126.19	125.72	126.13	2199706.0
2008-07-18 09:00:00	SPY	ETF	126.14	126.26	125.95	126.18	5171593.0
2008-07-18 09:30:00	SPY	ETF	126.17	126.39	125.24	125.41	39984841.0
2008-07-18 10:00:00	SPY	ETF	125.42	125.72	125.22	125.64	21043187.0
2008-07-18 10:30:00	SPY	ETF	125.64	126.4159	125.36	125.85	30843773.0
2008-07-18 11:00:00	SPY	ETF	125.86	126.29	125.72	126.095	23076276.0
2008-07-18 11:30:00	SPY	ETF	126.09	126.16	125.5	125.71	10920276.0
2008-07-18 12:00:00	SPY	ETF	125.72	126.0	125.4	125.48	11308377.0
2008-07-18 12:30:00	SPY	ETF	125.49	125.67	125.21	125.29	12373902.0
2008-07-18 13:00:00	SPY	ETF	125.3	125.6	125.15	125.53	11498516.0
2008-07-18 13:30:00	SPY	ETF	125.53	125.84	125.37	125.62	10966102.0
2008-07-18 14:00:00	SPY	ETF	125.63	125.96	125.35	125.85	9692080.0
2008-07-18 14:30:00	SPY	ETF	125.85	125.87	125.35	125.4902	11085926.0
2008-07-18 15:00:00	SPY	ETF	125.49	125.75	125.4	125.65	12260852.0
2008-07-18 15:30:00	SPY	ETF	125.66	126.14	125.62	125.92	20344929.0
2008-07-18 16:00:00	SPY	ETF	125.82	126.08	125.42	126.0	12093622.0
2008-07-18 16:30:00	SPY	ETF	126.01	126.03	125.98	125.99	7718245.0
2008-07-18 17:00:00	SPY	ETF	125.99	126.03	125.95	126.03	1105523.0
2008-07-18 17:30:00	SPY	ETF	125.99	126.0	125.99	126.0	4990.0
2008-07-18 18:00:00	SPY	ETF	126.0	126.07	126.0	126.06	24974.0
2008-07-18 18:30:00	SPY	ETF	126.05	126.05	126.0	126.0	18572.0
2008-07-18 19:00:00	SPY	ETF	126.0	126.06	126.0	126.06	4961.0
2008-07-18 19:30:00	SPY	ETF	126.04	126.06	126.03	126.04	3890.0
2008-07-18 04:30:00	QQQ	ETF	44.87	44.87	44.84	44.85	2000.0
2008-07-18 05:00:00	QQQ	ETF	44.77	44.79	44.77	44.79	800.0
2008-07-18 05:30:00	QQQ	ETF	44.77	44.77	44.76	44.76	200.0
2008-07-18 06:30:00	QQQ	ETF	44.98	45.13	44.97	45.13	5900.0
2008-07-18 07:00:00	QQQ	ETF	45.11	45.21	45.08	45.18	370372.0
2008-07-18 07:30:00	QQQ	ETF	45.18	45.23	45.11	45.14	302067.0
2008-07-18 08:00:00	QQQ	ETF	45.13	45.34	45.09	45.32	2044960.0
2008-07-18 08:30:00	QQQ	ETF	45.31	45.32	45.06	45.17	3972785.0
2008-07-18 09:00:00	QQQ	ETF	45.18	45.23	45.09	45.17	1471568.0
2008-07-18 09:30:00	QQQ	ETF	45.17	45.17	44.72	44.8	25138646.0
2008-07-18 10:00:00	QQQ	ETF	44.8	44.91	44.72	44.85	13580051.0
2008-07-18 10:30:00	QQQ	ETF	44.85	44.98	44.67	44.84	14940699.0
2008-07-18 11:00:00	QQQ	ETF	44.84	45.15	44.81	45.02	12710125.0
2008-07-18 11:30:00	QQQ	ETF	45.02	45.13	44.99	45.01	8934129.0
2008-07-18 12:00:00	QQQ	ETF	45.02	45.05	44.74	44.78	10656708.0
2008-07-18 12:30:00	QQQ	ETF	44.78	44.8499	44.68	44.7	7018632.0
2008-07-18 13:00:00	QQQ	ETF	44.71	44.86	44.69	44.7701	5994869.0
2008-07-18 13:30:00	QQQ	ETF	44.77	44.9	44.71	44.76	7316371.0
2008-07-18 14:00:00	QQQ	ETF	44.7603	44.88	44.71	44.82	3795283.0

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

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