PREVIEW / etf_30min / 2010-01-22

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-22.parquet
  size:    260 KB
  rows:    8,534

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
2010-01-22 04:00:00	SPY	ETF	111.85	111.92	111.85	111.92	4450.0
2010-01-22 04:30:00	SPY	ETF	111.96	111.96	111.88	111.88	400.0
2010-01-22 05:00:00	SPY	ETF	111.92	111.92	111.74	111.77	12600.0
2010-01-22 05:30:00	SPY	ETF	111.79	111.79	111.64	111.64	1500.0
2010-01-22 06:00:00	SPY	ETF	111.74	111.74	111.53	111.55	8600.0
2010-01-22 06:30:00	SPY	ETF	111.62	111.74	110.98	111.1	119800.0
2010-01-22 07:00:00	SPY	ETF	111.15	111.42	111.14	111.39	220461.0
2010-01-22 07:30:00	SPY	ETF	111.42	111.46	111.2	111.35	655046.0
2010-01-22 08:00:00	SPY	ETF	111.34	111.46	111.21	111.43	1424367.0
2010-01-22 08:30:00	SPY	ETF	111.43	111.54	111.1	111.11	2952126.0
2010-01-22 09:00:00	SPY	ETF	111.11	111.42	111.11	111.22	3553664.0
2010-01-22 09:30:00	SPY	ETF	111.2	111.62	111.01	111.33	40128800.0
2010-01-22 10:00:00	SPY	ETF	111.33	111.4	110.55	111.18	31947360.0
2010-01-22 10:30:00	SPY	ETF	111.19	111.43	110.97	111.35	23541665.0
2010-01-22 11:00:00	SPY	ETF	111.36	111.61	111.13	111.56	22254971.0
2010-01-22 11:30:00	SPY	ETF	111.558	111.59	110.9333	111.19	12368391.0
2010-01-22 12:00:00	SPY	ETF	111.18	111.36	111.0	111.34	10387437.0
2010-01-22 12:30:00	SPY	ETF	111.34	111.44	111.055	111.08	11941763.0
2010-01-22 13:00:00	SPY	ETF	111.0897	111.13	110.88	110.96	11038199.0
2010-01-22 13:30:00	SPY	ETF	110.97	111.0	110.59	110.74	14729866.0
2010-01-22 14:00:00	SPY	ETF	110.7495	110.88	110.52	110.59	14840262.0
2010-01-22 14:30:00	SPY	ETF	110.6	110.73	109.5	110.05	22041319.0
2010-01-22 15:00:00	SPY	ETF	110.05	110.28	109.44	109.6999	42988658.0
2010-01-22 15:30:00	SPY	ETF	109.7	109.79	109.09	109.22	52860043.0
2010-01-22 16:00:00	SPY	ETF	109.23	111.7416	109.16	109.54	19576605.0
2010-01-22 16:30:00	SPY	ETF	109.52	111.7416	109.2493	109.45	3015296.0
2010-01-22 17:00:00	SPY	ETF	109.45	109.45	109.13	109.18	434854.0
2010-01-22 17:30:00	SPY	ETF	109.28	109.45	109.17	109.26	463512.0
2010-01-22 18:00:00	SPY	ETF	109.26	109.45	109.22	109.45	221238.0
2010-01-22 18:30:00	SPY	ETF	109.45	109.47	109.31	109.37	47923.0
2010-01-22 19:00:00	SPY	ETF	109.32	109.38	109.22	109.32	14578.0
2010-01-22 19:30:00	SPY	ETF	109.32	109.35	109.22	109.27	31381.0
2010-01-22 04:00:00	QQQ	ETF	45.41	45.45	45.41	45.45	715.0
2010-01-22 05:00:00	QQQ	ETF	45.41	45.41	45.41	45.41	300.0
2010-01-22 05:30:00	QQQ	ETF	45.43	45.43	45.35	45.37	6255.0
2010-01-22 06:00:00	QQQ	ETF	45.39	45.39	45.34	45.34	300.0
2010-01-22 06:30:00	QQQ	ETF	45.38	45.39	45.17	45.22	69825.0
2010-01-22 07:00:00	QQQ	ETF	45.26	45.34	45.25	45.32	33491.0
2010-01-22 07:30:00	QQQ	ETF	45.34	45.37	45.25	45.33	126992.0
2010-01-22 08:00:00	QQQ	ETF	45.34	45.48	45.3	45.41	500001.0
2010-01-22 08:30:00	QQQ	ETF	45.41	45.44	45.35	45.35	498245.0
2010-01-22 09:00:00	QQQ	ETF	45.35	45.45	45.34	45.35	620111.0
2010-01-22 09:30:00	QQQ	ETF	45.34	45.48	45.18	45.32	19827791.0
2010-01-22 10:00:00	QQQ	ETF	45.32	45.3299	44.9	45.15	19152391.0
2010-01-22 10:30:00	QQQ	ETF	45.15	45.21	44.96	45.09	9687682.0
2010-01-22 11:00:00	QQQ	ETF	45.08	45.28	45.08	45.22	13891759.0
2010-01-22 11:30:00	QQQ	ETF	45.22	45.23	45.04	45.1	5087154.0
2010-01-22 12:00:00	QQQ	ETF	45.09	45.16	45.03	45.16	4791025.0
2010-01-22 12:30:00	QQQ	ETF	45.16	45.17	45.03	45.05	6268539.0
2010-01-22 13:00:00	QQQ	ETF	45.06	45.07	44.96	45.0	4152419.0

> showing 50 of 8,534 rows — these rows as CSV

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