PREVIEW / etf_30min / 2008-05-22

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-22.parquet
  size:    165 KB
  rows:    5,757

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-22 04:00:00	SPY	ETF	140.04	140.04	140.04	140.04	100.0
2008-05-22 06:00:00	SPY	ETF	139.66	139.66	139.66	139.66	10000.0
2008-05-22 06:30:00	SPY	ETF	139.64	139.68	139.56	139.56	13200.0
2008-05-22 07:00:00	SPY	ETF	139.78	139.78	139.57	139.59	150000.0
2008-05-22 07:30:00	SPY	ETF	139.59	139.6	139.26	139.28	603314.0
2008-05-22 08:00:00	SPY	ETF	139.31	140.04	139.24	139.39	2188962.0
2008-05-22 08:30:00	SPY	ETF	139.44	139.76	139.35	139.69	1723123.0
2008-05-22 09:00:00	SPY	ETF	139.67	139.72	139.45	139.45	1586626.0
2008-05-22 09:30:00	SPY	ETF	139.43	139.7	139.28	139.469	19869611.0
2008-05-22 10:00:00	SPY	ETF	139.46	139.95	139.46	139.92	17669631.0
2008-05-22 10:30:00	SPY	ETF	139.9205	140.16	139.6	139.85	17933017.0
2008-05-22 11:00:00	SPY	ETF	139.85	140.05	139.75	139.83	9781275.0
2008-05-22 11:30:00	SPY	ETF	139.82	139.86	139.0	139.48	12614615.0
2008-05-22 12:00:00	SPY	ETF	139.48	139.58	139.23	139.54	8915693.0
2008-05-22 12:30:00	SPY	ETF	139.54	139.83	139.44	139.78	8792280.0
2008-05-22 13:00:00	SPY	ETF	139.78	139.86	139.61	139.65	5194989.0
2008-05-22 13:30:00	SPY	ETF	139.66	140.17	139.57	139.92	9127212.0
2008-05-22 14:00:00	SPY	ETF	139.92	140.08	139.4	139.48	13157668.0
2008-05-22 14:30:00	SPY	ETF	139.48	139.95	139.4	139.8	8147768.0
2008-05-22 15:00:00	SPY	ETF	139.81	139.92	139.36	139.38	14425980.0
2008-05-22 15:30:00	SPY	ETF	139.38	139.75	139.32	139.56	12223736.0
2008-05-22 16:00:00	SPY	ETF	139.53	139.6861	139.5	139.59	2057307.0
2008-05-22 16:30:00	SPY	ETF	139.59	139.65	139.37	139.51	3061298.0
2008-05-22 17:00:00	SPY	ETF	139.51	139.55	139.5	139.51	45236.0
2008-05-22 17:30:00	SPY	ETF	139.51	139.52	139.5	139.5	5638.0
2008-05-22 18:00:00	SPY	ETF	139.52	139.53	139.48	139.49	7100.0
2008-05-22 18:30:00	SPY	ETF	139.5	139.54	139.5	139.54	5000.0
2008-05-22 19:00:00	SPY	ETF	139.53	139.57	139.53	139.57	5300.0
2008-05-22 19:30:00	SPY	ETF	139.58	139.58	139.45	139.45	8060.0
2008-05-22 04:00:00	QQQ	ETF	48.4	48.4	48.4	48.4	200.0
2008-05-22 04:30:00	QQQ	ETF	48.46	48.46	48.46	48.46	200.0
2008-05-22 05:30:00	QQQ	ETF	48.44	48.47	48.44	48.46	1400.0
2008-05-22 06:00:00	QQQ	ETF	48.35	48.35	48.3	48.3	1100.0
2008-05-22 06:30:00	QQQ	ETF	48.36	48.36	48.36	48.36	500.0
2008-05-22 07:00:00	QQQ	ETF	48.4	48.4	48.27	48.27	231500.0
2008-05-22 07:30:00	QQQ	ETF	48.28	48.29	48.17	48.17	602960.0
2008-05-22 08:00:00	QQQ	ETF	48.17	48.22	48.1	48.15	1317699.0
2008-05-22 08:30:00	QQQ	ETF	48.15	48.32	48.14	48.3	899980.0
2008-05-22 09:00:00	QQQ	ETF	48.3	48.36	48.27	48.3	728139.0
2008-05-22 09:30:00	QQQ	ETF	48.3	48.47	48.13	48.2701	20134006.0
2008-05-22 10:00:00	QQQ	ETF	48.28	48.52	48.26	48.48	15674465.0
2008-05-22 10:30:00	QQQ	ETF	48.48	48.69	48.33	48.47	12860335.0
2008-05-22 11:00:00	QQQ	ETF	48.46	48.56	48.38	48.47	6329456.0
2008-05-22 11:30:00	QQQ	ETF	48.47	48.48	48.2	48.35	7240321.0
2008-05-22 12:00:00	QQQ	ETF	48.35	48.41	48.24	48.38	7055220.0
2008-05-22 12:30:00	QQQ	ETF	48.38	48.61	48.35	48.53	7910278.0
2008-05-22 13:00:00	QQQ	ETF	48.53	48.58	48.4	48.45	3115229.0
2008-05-22 13:30:00	QQQ	ETF	48.45	48.63	48.4	48.44	4477666.0
2008-05-22 14:00:00	QQQ	ETF	48.45	48.58	48.1509	48.22	12266566.0
2008-05-22 14:30:00	QQQ	ETF	48.22	48.39	48.11	48.32	9972511.0

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

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