PREVIEW / etf_30min / 2007-09-24

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-24.parquet
  size:    129 KB
  rows:    4,875

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
2007-09-24 04:30:00	SPY	ETF	152.24	152.24	152.24	152.24	200.0
2007-09-24 06:30:00	SPY	ETF	152.41	152.45	152.41	152.45	55000.0
2007-09-24 07:00:00	SPY	ETF	152.45	152.49	152.25	152.25	174200.0
2007-09-24 07:30:00	SPY	ETF	152.27	152.47	152.27	152.41	125500.0
2007-09-24 08:00:00	SPY	ETF	152.41	152.51	152.1	152.44	1221100.0
2007-09-24 08:30:00	SPY	ETF	152.43	152.46	151.85	152.37	296100.0
2007-09-24 09:00:00	SPY	ETF	152.37	152.44	152.34	152.41	761700.0
2007-09-24 09:30:00	SPY	ETF	152.42	152.49	151.93	152.02	11506217.0
2007-09-24 10:00:00	SPY	ETF	152.01	152.79	151.97	152.78	12589700.0
2007-09-24 10:30:00	SPY	ETF	152.78	152.79	152.47	152.64	10572300.0
2007-09-24 11:00:00	SPY	ETF	152.65	152.82	152.44	152.68	9454600.0
2007-09-24 11:30:00	SPY	ETF	152.68	152.7	152.45	152.52	4112400.0
2007-09-24 12:00:00	SPY	ETF	152.51	152.65	152.39	152.54	6288900.0
2007-09-24 12:30:00	SPY	ETF	152.54	152.55	152.28	152.39	6018600.0
2007-09-24 13:00:00	SPY	ETF	152.38	152.42	151.97	152.06	10450800.0
2007-09-24 13:30:00	SPY	ETF	152.06	152.07	151.65	151.79	13536400.0
2007-09-24 14:00:00	SPY	ETF	151.79	151.98	151.57	151.58	8366600.0
2007-09-24 14:30:00	SPY	ETF	151.58	151.75	151.42	151.68	12453500.0
2007-09-24 15:00:00	SPY	ETF	151.67	151.78	151.36	151.78	10731200.0
2007-09-24 15:30:00	SPY	ETF	151.78	151.79	151.41	151.55	9637800.0
2007-09-24 16:00:00	SPY	ETF	151.57	152.4	151.5484	151.7	4619200.0
2007-09-24 16:30:00	SPY	ETF	151.7	151.7	151.58	151.64	1379700.0
2007-09-24 17:00:00	SPY	ETF	151.6	151.64	151.44	151.53	702900.0
2007-09-24 17:30:00	SPY	ETF	151.5	151.5	151.23	151.3	431600.0
2007-09-24 18:00:00	SPY	ETF	151.3	151.49	151.24	151.39	1201000.0
2007-09-24 18:30:00	SPY	ETF	151.37	151.37	151.24	151.26	107900.0
2007-09-24 19:00:00	SPY	ETF	151.28	151.28	151.23	151.26	42400.0
2007-09-24 19:30:00	SPY	ETF	151.24	151.32	151.23	151.32	63300.0
2007-09-24 07:00:00	QQQ	ETF	50.46	50.46	50.41	50.41	41870.0
2007-09-24 07:30:00	QQQ	ETF	50.42	50.53	50.42	50.52	60300.0
2007-09-24 08:00:00	QQQ	ETF	50.5	50.53	50.4	50.53	225667.0
2007-09-24 08:30:00	QQQ	ETF	50.52	50.53	50.5	50.5	101191.0
2007-09-24 09:00:00	QQQ	ETF	50.51	50.53	50.49	50.5	347439.0
2007-09-24 09:30:00	QQQ	ETF	50.51	50.6	50.43	50.4699	9810617.0
2007-09-24 10:00:00	QQQ	ETF	50.46	50.94	50.44	50.92	12451822.0
2007-09-24 10:30:00	QQQ	ETF	50.92	50.96	50.84	50.9	8484098.0
2007-09-24 11:00:00	QQQ	ETF	50.9	50.94	50.84	50.8805	5707098.0
2007-09-24 11:30:00	QQQ	ETF	50.88	50.89	50.8	50.85	3167940.0
2007-09-24 12:00:00	QQQ	ETF	50.8419	50.91	50.83	50.87	3287675.0
2007-09-24 12:30:00	QQQ	ETF	50.8601	50.87	50.75	50.79	4645270.0
2007-09-24 13:00:00	QQQ	ETF	50.79	50.79	50.6	50.64	10812152.0
2007-09-24 13:30:00	QQQ	ETF	50.64	50.64	50.44	50.49	13042213.0
2007-09-24 14:00:00	QQQ	ETF	50.49	50.57	50.4	50.4	6135333.0
2007-09-24 14:30:00	QQQ	ETF	50.4	50.505	50.33	50.49	7228756.0
2007-09-24 15:00:00	QQQ	ETF	50.5	50.53	50.37	50.5287	8250267.0
2007-09-24 15:30:00	QQQ	ETF	50.52	50.59	50.46	50.58	7037083.0
2007-09-24 16:00:00	QQQ	ETF	50.58	50.94	50.3865	50.57	5122422.0
2007-09-24 16:30:00	QQQ	ETF	50.57	50.58	50.386	50.57	815332.0
2007-09-24 17:00:00	QQQ	ETF	50.56	50.59	50.51	50.51	72165.0
2007-09-24 17:30:00	QQQ	ETF	50.53	50.57	50.51	50.53	309620.0

> showing 50 of 4,875 rows — these rows as CSV

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