PREVIEW / etf_30min / 2008-05-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-29.parquet
  size:    164 KB
  rows:    5,636

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-29 04:00:00	SPY	ETF	139.72	139.8	139.62	139.64	19200.0
2008-05-29 04:30:00	SPY	ETF	139.66	139.66	139.64	139.65	5100.0
2008-05-29 06:00:00	SPY	ETF	139.42	139.42	139.29	139.31	101300.0
2008-05-29 06:30:00	SPY	ETF	139.35	139.38	139.25	139.25	104200.0
2008-05-29 07:00:00	SPY	ETF	139.33	139.4	139.27	139.34	77200.0
2008-05-29 07:30:00	SPY	ETF	139.37	139.54	139.36	139.5	553380.0
2008-05-29 08:00:00	SPY	ETF	139.5	139.59	139.42	139.59	475577.0
2008-05-29 08:30:00	SPY	ETF	139.6	139.65	139.04	139.04	1664677.0
2008-05-29 09:00:00	SPY	ETF	139.05	139.15	138.97	139.12	1033365.0
2008-05-29 09:30:00	SPY	ETF	139.13	139.63	139.1	139.53	12645415.0
2008-05-29 10:00:00	SPY	ETF	139.53	139.75	139.115	139.6	16486194.0
2008-05-29 10:30:00	SPY	ETF	139.61	140.14	139.08	139.96	25519750.0
2008-05-29 11:00:00	SPY	ETF	139.95	140.19	139.85	140.025	12311345.0
2008-05-29 11:30:00	SPY	ETF	140.02	140.37	139.94	140.2796	11532066.0
2008-05-29 12:00:00	SPY	ETF	140.27	140.33	140.0	140.29	6177422.0
2008-05-29 12:30:00	SPY	ETF	140.28	140.79	140.25	140.67	14282785.0
2008-05-29 13:00:00	SPY	ETF	140.68	140.78	140.47	140.51	6444203.0
2008-05-29 13:30:00	SPY	ETF	140.52	140.71	140.45	140.58	5893442.0
2008-05-29 14:00:00	SPY	ETF	140.57	140.93	140.49	140.64	10869733.0
2008-05-29 14:30:00	SPY	ETF	140.65	140.7	140.27	140.38	13021792.0
2008-05-29 15:00:00	SPY	ETF	140.38	140.4	139.96	140.03	13979542.0
2008-05-29 15:30:00	SPY	ETF	140.04	140.29	139.97	140.03	14527938.0
2008-05-29 16:00:00	SPY	ETF	140.0299	140.22	139.96	140.05	3167873.0
2008-05-29 16:30:00	SPY	ETF	140.03	140.16	140.0	140.14	308573.0
2008-05-29 17:00:00	SPY	ETF	140.15	140.16	140.04	140.09	128726.0
2008-05-29 17:30:00	SPY	ETF	140.06	140.11	140.0	140.08	14700.0
2008-05-29 18:00:00	SPY	ETF	140.11	140.11	140.06	140.06	23275.0
2008-05-29 18:30:00	SPY	ETF	140.0	140.01	139.79	139.82	54838.0
2008-05-29 19:00:00	SPY	ETF	139.84	139.92	139.84	139.92	12746.0
2008-05-29 19:30:00	SPY	ETF	139.94	139.96	139.91	139.92	4400.0
2008-05-29 04:00:00	QQQ	ETF	49.43	49.43	49.42	49.42	10000.0
2008-05-29 06:00:00	QQQ	ETF	49.38	49.38	49.31	49.31	800.0
2008-05-29 06:30:00	QQQ	ETF	49.28	49.28	49.26	49.26	1200.0
2008-05-29 07:00:00	QQQ	ETF	49.29	49.29	49.26	49.28	3448.0
2008-05-29 07:30:00	QQQ	ETF	49.28	49.36	49.28	49.33	148259.0
2008-05-29 08:00:00	QQQ	ETF	49.29	49.45	49.29	49.38	377449.0
2008-05-29 08:30:00	QQQ	ETF	49.4	49.41	49.17	49.18	1080811.0
2008-05-29 09:00:00	QQQ	ETF	49.18	49.27	49.18	49.27	666650.0
2008-05-29 09:30:00	QQQ	ETF	49.26	49.56	49.26	49.52	13022333.0
2008-05-29 10:00:00	QQQ	ETF	49.52	49.6	49.32	49.52	10727336.0
2008-05-29 10:30:00	QQQ	ETF	49.53	49.65	49.25	49.54	22040219.0
2008-05-29 11:00:00	QQQ	ETF	49.54	49.6	49.45	49.53	9358981.0
2008-05-29 11:30:00	QQQ	ETF	49.52	49.74	49.51	49.6776	9777621.0
2008-05-29 12:00:00	QQQ	ETF	49.68	49.73	49.61	49.73	5952356.0
2008-05-29 12:30:00	QQQ	ETF	49.72	49.9	49.6	49.84	8982858.0
2008-05-29 13:00:00	QQQ	ETF	49.84	49.91	49.76	49.78	5284575.0
2008-05-29 13:30:00	QQQ	ETF	49.7701	49.85	49.76	49.77	3553460.0
2008-05-29 14:00:00	QQQ	ETF	49.78	49.97	49.73	49.863	8292202.0
2008-05-29 14:30:00	QQQ	ETF	49.863	49.91	49.72	49.78	6457061.0
2008-05-29 15:00:00	QQQ	ETF	49.77	49.81	49.65	49.69	8523263.0

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

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