PREVIEW / etf_30min / 2008-03-06

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-06.parquet
  size:    160 KB
  rows:    5,752

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-03-06 04:00:00	SPY	ETF	133.55	133.55	133.55	133.55	400.0
2008-03-06 04:30:00	SPY	ETF	133.52	133.52	133.35	133.35	20700.0
2008-03-06 05:00:00	SPY	ETF	133.25	133.25	133.13	133.13	9500.0
2008-03-06 05:30:00	SPY	ETF	133.04	133.19	133.0	133.14	71000.0
2008-03-06 06:00:00	SPY	ETF	133.23	133.33	133.14	133.28	20800.0
2008-03-06 06:30:00	SPY	ETF	133.35	133.55	133.3	133.38	35900.0
2008-03-06 07:00:00	SPY	ETF	133.4	133.61	133.36	133.36	391000.0
2008-03-06 07:30:00	SPY	ETF	133.35	133.46	133.0	133.09	1221700.0
2008-03-06 08:00:00	SPY	ETF	133.08	133.55	132.53	132.7	3321700.0
2008-03-06 08:30:00	SPY	ETF	132.71	133.83	132.49	132.67	5544500.0
2008-03-06 09:00:00	SPY	ETF	132.67	133.45	132.66	132.99	3897700.0
2008-03-06 09:30:00	SPY	ETF	132.98	133.22	132.43	132.62	28456728.0
2008-03-06 10:00:00	SPY	ETF	132.62	132.63	131.93	132.39	28356058.0
2008-03-06 10:30:00	SPY	ETF	132.39	132.72	132.13	132.42	14807019.0
2008-03-06 11:00:00	SPY	ETF	132.42	132.54	131.88	132.16	15388173.0
2008-03-06 11:30:00	SPY	ETF	132.16	132.5	131.91	132.24	10904084.0
2008-03-06 12:00:00	SPY	ETF	132.24	132.24	131.55	131.82	16586330.0
2008-03-06 12:30:00	SPY	ETF	131.83	132.22	131.67	131.78	8293497.0
2008-03-06 13:00:00	SPY	ETF	131.79	132.09	131.65	131.66	10058208.0
2008-03-06 13:30:00	SPY	ETF	131.66	132.04	131.48	131.8299	10242556.0
2008-03-06 14:00:00	SPY	ETF	131.82	132.16	131.57	131.61	8802704.0
2008-03-06 14:30:00	SPY	ETF	131.61	132.03	131.5	131.73	8955442.0
2008-03-06 15:00:00	SPY	ETF	131.73	131.89	131.14	131.76	22486393.0
2008-03-06 15:30:00	SPY	ETF	131.76	131.95	130.66	130.82	35934693.0
2008-03-06 16:00:00	SPY	ETF	130.77	132.5	130.55	131.03	4721800.0
2008-03-06 16:30:00	SPY	ETF	131.03	131.28	130.94	131.25	2545927.0
2008-03-06 17:00:00	SPY	ETF	131.22	131.22	131.04	131.04	177900.0
2008-03-06 17:30:00	SPY	ETF	131.04	131.17	130.95	131.08	130800.0
2008-03-06 18:00:00	SPY	ETF	131.06	131.18	130.7672	131.15	1923700.0
2008-03-06 18:30:00	SPY	ETF	131.18	131.22	131.13	131.17	64600.0
2008-03-06 19:00:00	SPY	ETF	131.17	131.18	130.98	131.0	33300.0
2008-03-06 19:30:00	SPY	ETF	131.0	131.12	130.9	131.12	44900.0
2008-03-06 04:00:00	QQQ	ETF	43.16	43.22	43.16	43.22	800.0
2008-03-06 07:00:00	QQQ	ETF	43.2	43.32	43.19	43.29	246225.0
2008-03-06 07:30:00	QQQ	ETF	43.22	43.26	43.15	43.15	498120.0
2008-03-06 08:00:00	QQQ	ETF	43.15	43.3	42.91	42.95	1225410.0
2008-03-06 08:30:00	QQQ	ETF	42.98	43.08	42.9	43.0	1939451.0
2008-03-06 09:00:00	QQQ	ETF	43.0	43.11	43.0	43.09	1883411.0
2008-03-06 09:30:00	QQQ	ETF	43.09	43.27	43.08	43.11	14515075.0
2008-03-06 10:00:00	QQQ	ETF	43.11	43.23	42.91	43.14	16213220.0
2008-03-06 10:30:00	QQQ	ETF	43.15	43.25	43.06	43.1299	11406426.0
2008-03-06 11:00:00	QQQ	ETF	43.13	43.17	42.91	42.92	9274136.0
2008-03-06 11:30:00	QQQ	ETF	42.93	43.08	42.92	43.0	6494747.0
2008-03-06 12:00:00	QQQ	ETF	43.0	43.0	42.69	42.75	10906092.0
2008-03-06 12:30:00	QQQ	ETF	42.76	42.82	42.63	42.64	6188275.0
2008-03-06 13:00:00	QQQ	ETF	42.6499	42.75	42.51	42.53	7030444.0
2008-03-06 13:30:00	QQQ	ETF	42.52	42.65	42.45	42.54	7134341.0
2008-03-06 14:00:00	QQQ	ETF	42.53	42.67	42.5	42.5	4233337.0
2008-03-06 14:30:00	QQQ	ETF	42.51	42.67	42.45	42.55	6984208.0
2008-03-06 15:00:00	QQQ	ETF	42.56	42.6	42.34	42.571	13858242.0

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

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