PREVIEW / etf_30min / 2008-03-20

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-20.parquet
  size:    162 KB
  rows:    5,787

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-20 04:00:00	SPY	ETF	129.65	129.65	129.65	129.65	300.0
2008-03-20 04:30:00	SPY	ETF	129.7	129.77	129.67	129.77	700.0
2008-03-20 05:00:00	SPY	ETF	129.91	130.01	129.87	129.95	3000.0
2008-03-20 05:30:00	SPY	ETF	129.98	130.36	129.95	130.33	74200.0
2008-03-20 06:00:00	SPY	ETF	130.25	130.4	130.25	130.39	25300.0
2008-03-20 06:30:00	SPY	ETF	130.24	130.24	129.9	129.9	28600.0
2008-03-20 07:00:00	SPY	ETF	129.94	130.12	129.85	130.01	609600.0
2008-03-20 07:30:00	SPY	ETF	130.0	130.47	130.0	130.29	2174300.0
2008-03-20 08:00:00	SPY	ETF	130.32	130.37	128.55	130.05	2954000.0
2008-03-20 08:30:00	SPY	ETF	130.05	130.27	129.32	129.42	4388650.0
2008-03-20 09:00:00	SPY	ETF	129.44	130.4	129.37	130.02	3422700.0
2008-03-20 09:30:00	SPY	ETF	130.04	130.25	129.26	130.07	26768223.0
2008-03-20 10:00:00	SPY	ETF	130.0706	131.33	130.03	130.7	25839827.0
2008-03-20 10:30:00	SPY	ETF	130.7	131.2	130.49	131.19	16549151.0
2008-03-20 11:00:00	SPY	ETF	131.19	131.39	130.88	131.33	14423965.0
2008-03-20 11:30:00	SPY	ETF	131.34	131.36	130.51	130.6	14288612.0
2008-03-20 12:00:00	SPY	ETF	130.59	131.21	130.59	130.67	14355493.0
2008-03-20 12:30:00	SPY	ETF	130.67	130.86	130.33	130.59	9720517.0
2008-03-20 13:00:00	SPY	ETF	130.59	131.12	130.58	131.09	5893835.0
2008-03-20 13:30:00	SPY	ETF	131.1	131.62	131.02	131.54	11278518.0
2008-03-20 14:00:00	SPY	ETF	131.53	131.79	131.35	131.75	12399619.0
2008-03-20 14:30:00	SPY	ETF	131.74	132.42	131.7	132.36	15339254.0
2008-03-20 15:00:00	SPY	ETF	132.35	132.91	132.3	132.42	15645103.0
2008-03-20 15:30:00	SPY	ETF	132.43	132.86	132.12	132.73	26657335.0
2008-03-20 16:00:00	SPY	ETF	132.703	132.75	128.58	132.22	7661000.0
2008-03-20 16:30:00	SPY	ETF	132.2	132.29	132.1	132.23	2455740.0
2008-03-20 17:00:00	SPY	ETF	132.23	132.28	132.18	132.2	146900.0
2008-03-20 17:30:00	SPY	ETF	132.19	132.19	132.08	132.1	2084800.0
2008-03-20 18:00:00	SPY	ETF	132.1	132.16	129.64	132.1	2031900.0
2008-03-20 18:30:00	SPY	ETF	132.1	132.27	132.08	132.21	16200.0
2008-03-20 19:00:00	SPY	ETF	132.2	132.2	132.15	132.15	3700.0
2008-03-20 19:30:00	SPY	ETF	132.2	132.2	132.12	132.2	6100.0
2008-03-20 04:00:00	QQQ	ETF	42.33	42.33	42.33	42.33	500.0
2008-03-20 05:00:00	QQQ	ETF	42.33	42.33	42.33	42.33	100.0
2008-03-20 05:30:00	QQQ	ETF	42.29	42.36	42.26	42.36	105000.0
2008-03-20 06:00:00	QQQ	ETF	42.4	42.42	42.4	42.42	20200.0
2008-03-20 06:30:00	QQQ	ETF	42.35	42.35	42.35	42.35	640.0
2008-03-20 07:00:00	QQQ	ETF	42.35	42.39	42.33	42.37	104258.0
2008-03-20 07:30:00	QQQ	ETF	42.37	42.48	42.34	42.37	56045.0
2008-03-20 08:00:00	QQQ	ETF	42.41	42.48	42.34	42.45	850210.0
2008-03-20 08:30:00	QQQ	ETF	42.42	42.5	42.13	42.21	2847261.0
2008-03-20 09:00:00	QQQ	ETF	42.22	42.4	42.19	42.34	764480.0
2008-03-20 09:30:00	QQQ	ETF	42.35	42.37	42.1	42.36	16148897.0
2008-03-20 10:00:00	QQQ	ETF	42.3699	42.56	42.25	42.49	16063710.0
2008-03-20 10:30:00	QQQ	ETF	42.49	42.55	42.3401	42.5381	6554231.0
2008-03-20 11:00:00	QQQ	ETF	42.53	42.58	42.39	42.55	5896808.0
2008-03-20 11:30:00	QQQ	ETF	42.54	42.56	42.29	42.34	7915073.0
2008-03-20 12:00:00	QQQ	ETF	42.33	42.55	42.33	42.39	5944534.0
2008-03-20 12:30:00	QQQ	ETF	42.39	42.43	42.27	42.32	5548620.0
2008-03-20 13:00:00	QQQ	ETF	42.32	42.5	42.31	42.492	3814435.0

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

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