PREVIEW / etf_30min / 2009-04-29

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-29.parquet
  size:    215 KB
  rows:    7,206

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
2009-04-29 04:00:00	SPY	ETF	86.29	86.33	86.29	86.32	1426.0
2009-04-29 04:30:00	SPY	ETF	86.13	86.15	86.12	86.12	3300.0
2009-04-29 05:00:00	SPY	ETF	86.17	86.53	86.17	86.53	24900.0
2009-04-29 05:30:00	SPY	ETF	86.5	86.71	86.5	86.71	14000.0
2009-04-29 06:00:00	SPY	ETF	86.64	86.66	86.55	86.66	25739.0
2009-04-29 06:30:00	SPY	ETF	86.61	86.63	86.43	86.47	23089.0
2009-04-29 07:00:00	SPY	ETF	86.45	86.5	86.27	86.38	359543.0
2009-04-29 07:30:00	SPY	ETF	86.36	86.5	86.3	86.48	286497.0
2009-04-29 08:00:00	SPY	ETF	86.47	86.75	86.3	86.3	2078030.0
2009-04-29 08:30:00	SPY	ETF	86.63	86.71	86.14	86.44	4216584.0
2009-04-29 09:00:00	SPY	ETF	86.44	86.59	86.2	86.53	3021002.0
2009-04-29 09:30:00	SPY	ETF	86.52	86.94	86.3	86.91	24321088.0
2009-04-29 10:00:00	SPY	ETF	86.91	87.27	86.6	87.23	21970776.0
2009-04-29 10:30:00	SPY	ETF	87.23	87.56	87.17	87.39	19071415.0
2009-04-29 11:00:00	SPY	ETF	87.39	87.61	87.24	87.58	16052041.0
2009-04-29 11:30:00	SPY	ETF	87.58	87.61	87.34	87.35	11843082.0
2009-04-29 12:00:00	SPY	ETF	87.35	87.48	87.25	87.34	13975084.0
2009-04-29 12:30:00	SPY	ETF	87.33	87.44	87.28	87.3701	7628046.0
2009-04-29 13:00:00	SPY	ETF	87.37	87.88	87.36	87.83	13122179.0
2009-04-29 13:30:00	SPY	ETF	87.8299	87.87	87.68	87.68	9198708.0
2009-04-29 14:00:00	SPY	ETF	87.68	88.08	87.41	87.8	26737421.0
2009-04-29 14:30:00	SPY	ETF	87.8	88.36	87.5137	87.83	37676835.0
2009-04-29 15:00:00	SPY	ETF	87.83	87.97	86.35	87.27	25518653.0
2009-04-29 15:30:00	SPY	ETF	87.26	87.5599	86.85	87.44	48253750.0
2009-04-29 16:00:00	SPY	ETF	87.39	87.53	86.4	87.38	11039666.0
2009-04-29 16:30:00	SPY	ETF	87.38	87.5	87.22	87.35	4968854.0
2009-04-29 17:00:00	SPY	ETF	87.35	88.24	85.6376	87.43	9153353.0
2009-04-29 17:30:00	SPY	ETF	87.43	87.47	87.41	87.41	51831.0
2009-04-29 18:00:00	SPY	ETF	87.45	87.45	87.2	87.22	92044.0
2009-04-29 18:30:00	SPY	ETF	87.22	87.25	87.1	87.12	46703.0
2009-04-29 19:00:00	SPY	ETF	87.14	87.24	87.14	87.17	20600.0
2009-04-29 19:30:00	SPY	ETF	87.2	87.22	87.13	87.18	38095.0
2009-04-29 04:00:00	QQQ	ETF	33.73	33.73	33.73	33.73	130.0
2009-04-29 04:30:00	QQQ	ETF	33.67	33.67	33.67	33.67	200.0
2009-04-29 05:00:00	QQQ	ETF	33.68	33.75	33.68	33.75	700.0
2009-04-29 05:30:00	QQQ	ETF	33.8	33.87	33.8	33.87	3100.0
2009-04-29 06:30:00	QQQ	ETF	33.8	33.8	33.8	33.8	1000.0
2009-04-29 07:00:00	QQQ	ETF	33.8	33.82	33.75	33.77	139623.0
2009-04-29 07:30:00	QQQ	ETF	33.77	33.79	33.75	33.78	168512.0
2009-04-29 08:00:00	QQQ	ETF	33.77	33.83	33.69	33.78	1270802.0
2009-04-29 08:30:00	QQQ	ETF	33.67	33.86	33.5	33.76	1142109.0
2009-04-29 09:00:00	QQQ	ETF	33.76	33.78	33.7	33.75	828373.0
2009-04-29 09:30:00	QQQ	ETF	33.75	33.93	33.7	33.93	12587273.0
2009-04-29 10:00:00	QQQ	ETF	33.93	34.04	33.86	34.01	8912760.0
2009-04-29 10:30:00	QQQ	ETF	34.01	34.17	33.99	34.12	8771825.0
2009-04-29 11:00:00	QQQ	ETF	34.12	34.26	33.9195	34.22	9533087.0
2009-04-29 11:30:00	QQQ	ETF	34.23	34.24	34.1	34.16	5036436.0
2009-04-29 12:00:00	QQQ	ETF	34.1595	34.2	34.1	34.13	5325022.0
2009-04-29 12:30:00	QQQ	ETF	34.13	34.15	34.08	34.119	2863527.0
2009-04-29 13:00:00	QQQ	ETF	34.12	34.25	34.11	34.23	5068648.0

> showing 50 of 7,206 rows — these rows as CSV

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