PREVIEW / etf_30min / 2008-11-13

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-13.parquet
  size:    187 KB
  rows:    6,587

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-11-13 04:00:00	SPY	ETF	86.24	86.69	86.21	86.6	6400.0
2008-11-13 04:30:00	SPY	ETF	86.55	86.55	86.41	86.52	500.0
2008-11-13 05:00:00	SPY	ETF	86.28	86.28	85.31	85.52	1300.0
2008-11-13 05:30:00	SPY	ETF	85.51	85.51	84.94	85.22	600.0
2008-11-13 06:00:00	SPY	ETF	85.24	85.32	84.77	85.26	75700.0
2008-11-13 06:30:00	SPY	ETF	85.3	85.77	85.3	85.52	59500.0
2008-11-13 07:00:00	SPY	ETF	85.6	86.4	85.51	86.29	597420.0
2008-11-13 07:30:00	SPY	ETF	86.3	86.45	85.5	85.57	1265631.0
2008-11-13 08:00:00	SPY	ETF	85.58	86.37	84.759	85.33	3211589.0
2008-11-13 08:30:00	SPY	ETF	85.33	85.8	85.12	85.38	3117457.0
2008-11-13 09:00:00	SPY	ETF	85.42	86.17	85.4	86.13	2931336.0
2008-11-13 09:30:00	SPY	ETF	86.13	86.87	85.0	85.11	44034800.0
2008-11-13 10:00:00	SPY	ETF	85.12	87.08	85.02	86.57	46669670.0
2008-11-13 10:30:00	SPY	ETF	86.57	86.83	85.42	85.9	29795658.0
2008-11-13 11:00:00	SPY	ETF	85.9	86.14	84.97	85.91	32083753.0
2008-11-13 11:30:00	SPY	ETF	85.92	86.19	85.09	85.33	22551216.0
2008-11-13 12:00:00	SPY	ETF	85.34	85.58	84.38	84.552	25207334.0
2008-11-13 12:30:00	SPY	ETF	84.55	84.8	82.15	82.17	45454449.0
2008-11-13 13:00:00	SPY	ETF	82.16	84.1	82.09	84.1	60832724.0
2008-11-13 13:30:00	SPY	ETF	84.1	86.56	83.92	85.18	89428725.0
2008-11-13 14:00:00	SPY	ETF	85.2	87.56	84.87	87.14	59216034.0
2008-11-13 14:30:00	SPY	ETF	87.14	88.57	85.3651	87.6699	71981116.0
2008-11-13 15:00:00	SPY	ETF	87.66	89.21	86.2	89.2	74090849.0
2008-11-13 15:30:00	SPY	ETF	89.2	91.73	85.92	91.5	96322616.0
2008-11-13 16:00:00	SPY	ETF	91.46	91.61	85.7	91.07	20360990.0
2008-11-13 16:30:00	SPY	ETF	91.07	91.2	90.85	90.9	15138941.0
2008-11-13 17:00:00	SPY	ETF	90.9	91.24	90.89	91.16	3755523.0
2008-11-13 17:30:00	SPY	ETF	91.16	91.19	91.06	91.17	2510348.0
2008-11-13 18:00:00	SPY	ETF	91.16	91.26	90.95	91.21	176566.0
2008-11-13 18:30:00	SPY	ETF	91.21	91.27	91.08	91.12	42033.0
2008-11-13 19:00:00	SPY	ETF	91.08	91.08	90.7	90.73	338067.0
2008-11-13 19:30:00	SPY	ETF	90.73	90.9	90.62	90.62	165227.0
2008-11-13 04:00:00	QQQ	ETF	28.62	28.62	28.62	28.62	900.0
2008-11-13 04:30:00	QQQ	ETF	28.64	28.64	28.64	28.64	100.0
2008-11-13 05:00:00	QQQ	ETF	28.57	28.57	28.42	28.42	1700.0
2008-11-13 05:30:00	QQQ	ETF	28.38	28.38	28.22	28.32	5300.0
2008-11-13 06:00:00	QQQ	ETF	28.28	28.33	28.15	28.15	3700.0
2008-11-13 06:30:00	QQQ	ETF	28.26	28.42	28.26	28.32	1900.0
2008-11-13 07:00:00	QQQ	ETF	28.34	28.6	28.31	28.53	86636.0
2008-11-13 07:30:00	QQQ	ETF	28.59	28.67	28.37	28.37	218425.0
2008-11-13 08:00:00	QQQ	ETF	28.39	28.45	28.28	28.3	844577.0
2008-11-13 08:30:00	QQQ	ETF	28.3	28.4	28.24	28.38	1048788.0
2008-11-13 09:00:00	QQQ	ETF	28.39	28.65	28.38	28.63	990678.0
2008-11-13 09:30:00	QQQ	ETF	28.63	28.93	28.24	28.28	27358892.0
2008-11-13 10:00:00	QQQ	ETF	28.28	28.97	28.25	28.83	18949540.0
2008-11-13 10:30:00	QQQ	ETF	28.84	28.92	28.48	28.6	11868338.0
2008-11-13 11:00:00	QQQ	ETF	28.59	28.68	28.26	28.499	14098054.0
2008-11-13 11:30:00	QQQ	ETF	28.5	28.54	28.31	28.3499	9083562.0
2008-11-13 12:00:00	QQQ	ETF	28.35	28.42	27.98	28.01	10915442.0
2008-11-13 12:30:00	QQQ	ETF	28.02	28.1	27.3	27.3	19671987.0

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

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