PREVIEW / etf_30min / 2008-03-26

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-26.parquet
  size:    154 KB
  rows:    5,651

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-26 04:00:00	SPY	ETF	134.1	134.22	134.1	134.22	1100.0
2008-03-26 05:00:00	SPY	ETF	134.52	134.52	134.52	134.52	100.0
2008-03-26 05:30:00	SPY	ETF	134.37	134.42	134.35	134.35	7500.0
2008-03-26 06:00:00	SPY	ETF	134.45	134.7	134.45	134.7	28500.0
2008-03-26 06:30:00	SPY	ETF	134.5	134.5	134.23	134.29	79600.0
2008-03-26 07:00:00	SPY	ETF	134.33	134.51	134.22	134.29	228800.0
2008-03-26 07:30:00	SPY	ETF	134.3	134.58	134.12	134.17	575100.0
2008-03-26 08:00:00	SPY	ETF	134.17	134.6	134.15	134.5	1996700.0
2008-03-26 08:30:00	SPY	ETF	134.53	134.53	134.1	134.36	4086800.0
2008-03-26 09:00:00	SPY	ETF	134.34	134.47	134.31	134.45	889300.0
2008-03-26 09:30:00	SPY	ETF	134.46	134.46	133.84	134.14	22818415.0
2008-03-26 10:00:00	SPY	ETF	134.14	134.54	133.98	134.11	18643596.0
2008-03-26 10:30:00	SPY	ETF	134.12	134.14	133.45	133.78	22843051.0
2008-03-26 11:00:00	SPY	ETF	133.78	134.07	133.6	134.02	9400584.0
2008-03-26 11:30:00	SPY	ETF	134.02	134.19	133.75	133.99	8522758.0
2008-03-26 12:00:00	SPY	ETF	133.99	134.16	133.8	133.96	8086549.0
2008-03-26 12:30:00	SPY	ETF	133.94	135.0884	133.6	133.72	6580676.0
2008-03-26 13:00:00	SPY	ETF	133.72	133.91	133.65	133.75	5845452.0
2008-03-26 13:30:00	SPY	ETF	133.74	133.76	133.5	133.66	9528017.0
2008-03-26 14:00:00	SPY	ETF	133.66	134.03	133.5	133.83	9803090.0
2008-03-26 14:30:00	SPY	ETF	133.84	134.58	133.76	134.56	11053201.0
2008-03-26 15:00:00	SPY	ETF	134.56	134.59	133.69	133.78	20093150.0
2008-03-26 15:30:00	SPY	ETF	133.77	133.98	133.6	133.83	20193473.0
2008-03-26 16:00:00	SPY	ETF	133.82	134.56	133.11	133.23	6340900.0
2008-03-26 16:30:00	SPY	ETF	133.2	133.32	133.16	133.25	1406700.0
2008-03-26 17:00:00	SPY	ETF	133.26	133.34	133.15	133.23	153200.0
2008-03-26 17:30:00	SPY	ETF	133.27	133.27	133.15	133.15	21300.0
2008-03-26 18:00:00	SPY	ETF	133.19	133.19	132.92	132.97	207100.0
2008-03-26 18:30:00	SPY	ETF	133.0	133.06	132.94	133.05	26000.0
2008-03-26 19:00:00	SPY	ETF	133.09	133.09	133.04	133.07	5200.0
2008-03-26 19:30:00	SPY	ETF	133.07	133.25	133.03	133.25	18000.0
2008-03-26 06:30:00	QQQ	ETF	44.68	44.68	44.68	44.68	100.0
2008-03-26 07:00:00	QQQ	ETF	44.65	44.66	44.6	44.64	43572.0
2008-03-26 07:30:00	QQQ	ETF	44.64	44.7	44.56	44.6	250872.0
2008-03-26 08:00:00	QQQ	ETF	44.59	44.8681	44.59	44.68	7497636.0
2008-03-26 08:30:00	QQQ	ETF	44.63	44.7	44.55	44.61	1444743.0
2008-03-26 09:00:00	QQQ	ETF	44.62	44.7	44.61	44.69	794644.0
2008-03-26 09:30:00	QQQ	ETF	44.69	44.73	44.42	44.51	13254096.0
2008-03-26 10:00:00	QQQ	ETF	44.51	44.66	44.5	44.57	11052164.0
2008-03-26 10:30:00	QQQ	ETF	44.57	44.57	44.28	44.4801	12084889.0
2008-03-26 11:00:00	QQQ	ETF	44.48	44.55	44.4	44.5395	4604296.0
2008-03-26 11:30:00	QQQ	ETF	44.54	44.61	44.39	44.5	3464829.0
2008-03-26 12:00:00	QQQ	ETF	44.51	44.53	44.42	44.48	3024556.0
2008-03-26 12:30:00	QQQ	ETF	44.48	44.51	44.42	44.48	2110378.0
2008-03-26 13:00:00	QQQ	ETF	44.4701	44.55	44.4501	44.48	3204777.0
2008-03-26 13:30:00	QQQ	ETF	44.49	44.49	44.35	44.43	3838785.0
2008-03-26 14:00:00	QQQ	ETF	44.43	44.59	44.36	44.56	6082237.0
2008-03-26 14:30:00	QQQ	ETF	44.56	44.81	44.54	44.8	7799623.0
2008-03-26 15:00:00	QQQ	ETF	44.81	44.85	44.59	44.63	8578612.0
2008-03-26 15:30:00	QQQ	ETF	44.63	44.71	44.51	44.66	12582861.0

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

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