PREVIEW / etf_30min / 2008-07-16

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-16.parquet
  size:    182 KB
  rows:    6,108

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-07-16 04:00:00	SPY	ETF	121.4	121.4	121.4	121.4	1000.0
2008-07-16 04:30:00	SPY	ETF	121.35	121.36	121.35	121.36	1500.0
2008-07-16 05:00:00	SPY	ETF	121.32	121.32	121.15	121.15	8500.0
2008-07-16 05:30:00	SPY	ETF	121.17	121.17	120.91	120.92	9200.0
2008-07-16 06:00:00	SPY	ETF	120.85	120.85	120.25	120.52	48500.0
2008-07-16 06:30:00	SPY	ETF	120.54	120.8	120.52	120.52	286900.0
2008-07-16 07:00:00	SPY	ETF	120.5	120.87	120.35	120.81	296781.0
2008-07-16 07:30:00	SPY	ETF	120.88	120.88	120.48	120.66	774093.0
2008-07-16 08:00:00	SPY	ETF	120.6	121.84	120.26	121.6	5074858.0
2008-07-16 08:30:00	SPY	ETF	121.6	121.6	120.79	121.28	8588311.0
2008-07-16 09:00:00	SPY	ETF	121.3	121.65	121.21	121.46	4144377.0
2008-07-16 09:30:00	SPY	ETF	121.45	122.42	121.1	122.33	46367172.0
2008-07-16 10:00:00	SPY	ETF	122.33	122.48	121.25	121.87	29961343.0
2008-07-16 10:30:00	SPY	ETF	121.88	122.82	121.75	122.48	38686403.0
2008-07-16 11:00:00	SPY	ETF	122.48	122.9	122.13	122.359	25601149.0
2008-07-16 11:30:00	SPY	ETF	122.33	122.5	121.25	122.35	22632752.0
2008-07-16 12:00:00	SPY	ETF	122.35	122.87	122.22	122.79	13321590.0
2008-07-16 12:30:00	SPY	ETF	122.79	122.95	122.6	122.87	12934804.0
2008-07-16 13:00:00	SPY	ETF	122.87	123.34	122.73	123.21	20659622.0
2008-07-16 13:30:00	SPY	ETF	123.21	123.31	122.73	123.17	13102284.0
2008-07-16 14:00:00	SPY	ETF	123.17	123.59	122.68	123.355	30888701.0
2008-07-16 14:30:00	SPY	ETF	123.37	123.78	123.33	123.67	19347068.0
2008-07-16 15:00:00	SPY	ETF	123.66	124.0	123.49	123.97	18635558.0
2008-07-16 15:30:00	SPY	ETF	123.97	124.57	123.6	124.47	34405235.0
2008-07-16 16:00:00	SPY	ETF	124.451	124.52	121.85	124.0	8246087.0
2008-07-16 16:30:00	SPY	ETF	124.0	124.1	121.4914	124.05	9016960.0
2008-07-16 17:00:00	SPY	ETF	124.05	124.14	123.96	124.04	3328550.0
2008-07-16 17:30:00	SPY	ETF	121.49	124.08	121.49	123.95	1065300.0
2008-07-16 18:00:00	SPY	ETF	123.95	124.01	123.93	123.99	70800.0
2008-07-16 18:30:00	SPY	ETF	124.0	124.0	123.92	123.93	3700.0
2008-07-16 19:00:00	SPY	ETF	123.93	123.93	123.9	123.92	16150.0
2008-07-16 19:30:00	SPY	ETF	123.92	124.0	123.92	123.99	24623.0
2008-07-16 06:00:00	QQQ	ETF	43.88	43.89	43.84	43.89	1900.0
2008-07-16 06:30:00	QQQ	ETF	43.97	44.06	43.94	44.02	10100.0
2008-07-16 07:00:00	QQQ	ETF	43.85	44.11	43.85	44.04	344452.0
2008-07-16 07:30:00	QQQ	ETF	44.06	44.09	43.96	44.05	138558.0
2008-07-16 08:00:00	QQQ	ETF	44.05	44.49	44.05	44.43	5173767.0
2008-07-16 08:30:00	QQQ	ETF	44.38	44.38	44.12	44.25	4048051.0
2008-07-16 09:00:00	QQQ	ETF	44.23	44.4	44.21	44.3	1980777.0
2008-07-16 09:30:00	QQQ	ETF	44.3	44.47	43.92	44.42	28405845.0
2008-07-16 10:00:00	QQQ	ETF	44.42	44.46	44.07	44.31	13741493.0
2008-07-16 10:30:00	QQQ	ETF	44.31	44.76	44.24	44.67	22272544.0
2008-07-16 11:00:00	QQQ	ETF	44.68	44.9	44.57	44.61	16457775.0
2008-07-16 11:30:00	QQQ	ETF	44.61	44.75	44.51	44.69	8572139.0
2008-07-16 12:00:00	QQQ	ETF	44.69	44.8295	44.56	44.8	6489762.0
2008-07-16 12:30:00	QQQ	ETF	44.79	44.92	44.73	44.91	7593084.0
2008-07-16 13:00:00	QQQ	ETF	44.89	45.09	44.86	45.02	9189858.0
2008-07-16 13:30:00	QQQ	ETF	45.01	45.05	44.87	45.01	8237562.0
2008-07-16 14:00:00	QQQ	ETF	45.01	45.22	44.83	45.11	11845569.0
2008-07-16 14:30:00	QQQ	ETF	45.11	45.31	45.0801	45.27	9168353.0

> showing 50 of 6,108 rows — these rows as CSV

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