PREVIEW / etf_30min / 2007-09-21

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-21.parquet
  size:    123 KB
  rows:    4,751

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-21 04:30:00	SPY	ETF	152.29	152.38	152.29	152.38	5000.0
2007-09-21 05:00:00	SPY	ETF	152.39	152.41	152.39	152.41	1200.0
2007-09-21 05:30:00	SPY	ETF	152.46	152.46	152.36	152.44	6900.0
2007-09-21 06:00:00	SPY	ETF	152.34	152.36	152.29	152.32	21900.0
2007-09-21 06:30:00	SPY	ETF	152.46	152.46	152.32	152.32	30800.0
2007-09-21 07:00:00	SPY	ETF	152.38	152.66	152.31	152.58	624100.0
2007-09-21 07:30:00	SPY	ETF	152.55	152.59	152.45	152.53	406400.0
2007-09-21 08:00:00	SPY	ETF	152.54	152.57	152.42	152.51	833100.0
2007-09-21 08:30:00	SPY	ETF	152.5	152.92	151.72	152.81	3659700.0
2007-09-21 09:00:00	SPY	ETF	152.83	152.91	152.69	152.69	2308100.0
2007-09-21 09:30:00	SPY	ETF	152.71	152.8	152.29	152.32	17738909.0
2007-09-21 10:00:00	SPY	ETF	152.32	152.68	152.31	152.35	11186500.0
2007-09-21 10:30:00	SPY	ETF	152.35	152.62	152.28	152.47	8073200.0
2007-09-21 11:00:00	SPY	ETF	152.471	153.1177	152.44	152.7	8361600.0
2007-09-21 11:30:00	SPY	ETF	152.69	152.76	152.58	152.72	5650900.0
2007-09-21 12:00:00	SPY	ETF	152.72	152.75	152.62	152.72	3150000.0
2007-09-21 12:30:00	SPY	ETF	152.71	152.89	152.66	152.73	4186000.0
2007-09-21 13:00:00	SPY	ETF	152.73	152.77	152.63	152.72	23903800.0
2007-09-21 13:30:00	SPY	ETF	152.72	152.77	152.48	152.5	4491900.0
2007-09-21 14:00:00	SPY	ETF	152.5	152.54	152.38	152.5	5096900.0
2007-09-21 14:30:00	SPY	ETF	152.51	152.61	152.25	152.39	9504800.0
2007-09-21 15:00:00	SPY	ETF	152.39	152.68	152.36	152.53	6028100.0
2007-09-21 15:30:00	SPY	ETF	152.52	152.58	152.27	152.27	12035700.0
2007-09-21 16:00:00	SPY	ETF	152.26	152.64	151.6501	152.07	7624800.0
2007-09-21 16:30:00	SPY	ETF	152.07	152.1	151.97	152.05	3333800.0
2007-09-21 17:00:00	SPY	ETF	152.05	152.07	152.0	152.05	106500.0
2007-09-21 17:30:00	SPY	ETF	152.02	152.09	152.02	152.09	1800.0
2007-09-21 19:00:00	SPY	ETF	152.04	152.07	152.04	152.04	2600.0
2007-09-21 19:30:00	SPY	ETF	152.04	152.09	152.04	152.09	1500.0
2007-09-21 04:30:00	QQQ	ETF	50.28	50.28	50.28	50.28	10000.0
2007-09-21 06:30:00	QQQ	ETF	50.27	50.27	50.27	50.27	4000.0
2007-09-21 07:00:00	QQQ	ETF	50.25	50.31	50.24	50.31	96550.0
2007-09-21 07:30:00	QQQ	ETF	50.32	50.32	50.27	50.29	281968.0
2007-09-21 08:00:00	QQQ	ETF	50.28	50.3	50.24	50.29	1154388.0
2007-09-21 08:30:00	QQQ	ETF	50.3	50.42	50.29	50.39	1154093.0
2007-09-21 09:00:00	QQQ	ETF	50.39	50.42	50.28	50.29	2780006.0
2007-09-21 09:30:00	QQQ	ETF	50.28	50.35	50.19	50.23	12307873.0
2007-09-21 10:00:00	QQQ	ETF	50.23	50.35	50.23	50.27	6860593.0
2007-09-21 10:30:00	QQQ	ETF	50.26	50.38	50.23	50.36	4809849.0
2007-09-21 11:00:00	QQQ	ETF	50.36	50.47	50.36	50.46	4203250.0
2007-09-21 11:30:00	QQQ	ETF	50.46	50.51	50.41	50.47	3068804.0
2007-09-21 12:00:00	QQQ	ETF	50.478	50.478	50.4	50.45	2487853.0
2007-09-21 12:30:00	QQQ	ETF	50.45	50.51	50.44	50.45	2473897.0
2007-09-21 13:00:00	QQQ	ETF	50.45	50.47	50.37	50.41	2592546.0
2007-09-21 13:30:00	QQQ	ETF	50.42	50.43	50.34	50.35	1666362.0
2007-09-21 14:00:00	QQQ	ETF	50.35	50.41	50.0143	50.4078	5044966.0
2007-09-21 14:30:00	QQQ	ETF	50.41	50.45	50.35	50.39	2498388.0
2007-09-21 15:00:00	QQQ	ETF	50.39	50.52	50.38	50.48	4656782.0
2007-09-21 15:30:00	QQQ	ETF	50.48	50.49	50.35	50.37	8851245.0
2007-09-21 16:00:00	QQQ	ETF	50.37	50.43	50.27	50.33	3037813.0

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

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