PREVIEW / etf_30min / 2008-05-06

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-06.parquet
  size:    166 KB
  rows:    5,644

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-06 04:00:00	SPY	ETF	140.85	140.85	140.85	140.85	1300.0
2008-05-06 04:30:00	SPY	ETF	140.81	140.81	140.81	140.81	300.0
2008-05-06 05:00:00	SPY	ETF	140.72	140.72	140.72	140.72	100.0
2008-05-06 05:30:00	SPY	ETF	140.76	140.76	140.76	140.76	3000.0
2008-05-06 06:00:00	SPY	ETF	140.62	140.62	140.62	140.62	2100.0
2008-05-06 06:30:00	SPY	ETF	140.5	140.56	140.49	140.56	255100.0
2008-05-06 07:00:00	SPY	ETF	140.55	140.57	140.2	140.21	741097.0
2008-05-06 07:30:00	SPY	ETF	140.2	140.22	139.99	140.07	762198.0
2008-05-06 08:00:00	SPY	ETF	140.06	141.21	139.93	140.19	3112555.0
2008-05-06 08:30:00	SPY	ETF	140.17	140.19	139.89	139.91	919164.0
2008-05-06 09:00:00	SPY	ETF	139.91	140.02	139.82	140.0	779756.0
2008-05-06 09:30:00	SPY	ETF	140.01	140.11	139.69	139.95	16889346.0
2008-05-06 10:00:00	SPY	ETF	139.95	140.44	139.85	140.2	13528008.0
2008-05-06 10:30:00	SPY	ETF	140.2	140.62	140.02	140.6	11541364.0
2008-05-06 11:00:00	SPY	ETF	140.6	140.78	140.42	140.54	13879967.0
2008-05-06 11:30:00	SPY	ETF	140.53	140.86	140.4	140.86	6808582.0
2008-05-06 12:00:00	SPY	ETF	140.85	141.5	140.83	141.34	17083555.0
2008-05-06 12:30:00	SPY	ETF	141.35	141.71	141.14	141.62	12000227.0
2008-05-06 13:00:00	SPY	ETF	141.62	141.77	141.49	141.52	9101190.0
2008-05-06 13:30:00	SPY	ETF	141.51	141.75	141.41	141.61	11876676.0
2008-05-06 14:00:00	SPY	ETF	141.608	141.69	141.22	141.44	11917356.0
2008-05-06 14:30:00	SPY	ETF	141.44	141.87	141.32	141.81	8751118.0
2008-05-06 15:00:00	SPY	ETF	141.81	142.03	141.69	141.85	9105551.0
2008-05-06 15:30:00	SPY	ETF	141.86	142.2	141.76	141.84	16941809.0
2008-05-06 16:00:00	SPY	ETF	141.8699	142.18	141.4919	142.1	4477717.0
2008-05-06 16:30:00	SPY	ETF	142.1	142.25	140.7543	142.15	2223791.0
2008-05-06 17:00:00	SPY	ETF	142.11	142.11	140.7543	141.96	2544533.0
2008-05-06 17:30:00	SPY	ETF	141.99	142.05	141.97	141.97	35913.0
2008-05-06 18:00:00	SPY	ETF	141.95	142.03	141.94	142.0	13382.0
2008-05-06 18:30:00	SPY	ETF	142.01	142.06	142.01	142.06	1150.0
2008-05-06 19:00:00	SPY	ETF	142.07	142.14	142.06	142.14	10281.0
2008-05-06 19:30:00	SPY	ETF	142.11	142.2	142.11	142.2	1325.0
2008-05-06 05:00:00	QQQ	ETF	48.59	48.59	48.59	48.59	100.0
2008-05-06 06:00:00	QQQ	ETF	48.55	48.55	48.55	48.55	100.0
2008-05-06 06:30:00	QQQ	ETF	48.53	48.53	48.53	48.53	2600.0
2008-05-06 07:00:00	QQQ	ETF	48.53	48.53	48.42	48.44	122548.0
2008-05-06 07:30:00	QQQ	ETF	48.42	48.42	48.38	48.39	248100.0
2008-05-06 08:00:00	QQQ	ETF	48.4	48.47	48.36	48.44	532464.0
2008-05-06 08:30:00	QQQ	ETF	48.44	48.46	48.4	48.42	553391.0
2008-05-06 09:00:00	QQQ	ETF	48.42	48.46	48.38	48.46	1069550.0
2008-05-06 09:30:00	QQQ	ETF	48.47	48.51	48.14	48.23	16755967.0
2008-05-06 10:00:00	QQQ	ETF	48.24	48.35	48.15	48.29	11308856.0
2008-05-06 10:30:00	QQQ	ETF	48.2975	48.57	48.24	48.55	7111430.0
2008-05-06 11:00:00	QQQ	ETF	48.55	48.59	48.42	48.51	10533105.0
2008-05-06 11:30:00	QQQ	ETF	48.51	48.62	48.3	48.61	3949272.0
2008-05-06 12:00:00	QQQ	ETF	48.62	48.85	48.61	48.75	8363496.0
2008-05-06 12:30:00	QQQ	ETF	48.75	48.92	48.72	48.86	4716607.0
2008-05-06 13:00:00	QQQ	ETF	48.87	48.94	48.82	48.83	4259906.0
2008-05-06 13:30:00	QQQ	ETF	48.83	48.95	48.5	48.89	6192029.0
2008-05-06 14:00:00	QQQ	ETF	48.889	48.91	48.5791	48.84	4505481.0

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

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