PREVIEW / etf_30min / 2010-03-29

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-29.parquet
  size:    243 KB
  rows:    8,289

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-03-29 04:00:00	SPY	ETF	117.5	117.52	117.5	117.52	1850.0
2010-03-29 04:30:00	SPY	ETF	117.47	117.49	117.43	117.43	2300.0
2010-03-29 05:00:00	SPY	ETF	117.43	117.48	117.43	117.44	2200.0
2010-03-29 05:30:00	SPY	ETF	117.4	117.4	117.4	117.4	300.0
2010-03-29 06:00:00	SPY	ETF	117.42	117.45	117.42	117.45	19000.0
2010-03-29 06:30:00	SPY	ETF	117.4	117.45	117.35	117.36	11100.0
2010-03-29 07:00:00	SPY	ETF	117.37	117.45	117.36	117.39	63458.0
2010-03-29 07:30:00	SPY	ETF	117.4	117.41	117.24	117.27	72091.0
2010-03-29 08:00:00	SPY	ETF	117.25	117.7	117.24	117.34	749696.0
2010-03-29 08:30:00	SPY	ETF	117.32	117.33	117.15	117.18	729539.0
2010-03-29 09:00:00	SPY	ETF	117.17	117.2	117.06	117.16	1869457.0
2010-03-29 09:30:00	SPY	ETF	117.1699	117.43	117.08	117.12	22022150.0
2010-03-29 10:00:00	SPY	ETF	117.11	117.3	117.02	117.12	11246246.0
2010-03-29 10:30:00	SPY	ETF	117.12	117.32	116.97	117.29	11486755.0
2010-03-29 11:00:00	SPY	ETF	117.3	117.53	117.28	117.45	7282097.0
2010-03-29 11:30:00	SPY	ETF	117.45	117.47	117.3	117.368	4656805.0
2010-03-29 12:00:00	SPY	ETF	117.365	117.39	116.6886	117.29	5444215.0
2010-03-29 12:30:00	SPY	ETF	117.29	117.33	117.14	117.17	5880382.0
2010-03-29 13:00:00	SPY	ETF	117.18	117.34	117.16	117.2801	5000667.0
2010-03-29 13:30:00	SPY	ETF	117.28	117.35	117.11	117.23	6624950.0
2010-03-29 14:00:00	SPY	ETF	117.2399	117.31	117.06	117.19	8935057.0
2010-03-29 14:30:00	SPY	ETF	117.195	117.34	117.16	117.3338	7971953.0
2010-03-29 15:00:00	SPY	ETF	117.34	117.43	117.3	117.388	7556987.0
2010-03-29 15:30:00	SPY	ETF	117.38	117.39	117.26	117.34	12649403.0
2010-03-29 16:00:00	SPY	ETF	117.35	117.52	116.6886	117.34	12147051.0
2010-03-29 16:30:00	SPY	ETF	117.32	117.37	117.27	117.32	472545.0
2010-03-29 17:00:00	SPY	ETF	117.32	117.37	117.32	117.36	118693.0
2010-03-29 17:30:00	SPY	ETF	117.37	117.44	117.37	117.43	102606.0
2010-03-29 18:00:00	SPY	ETF	117.42	117.43	117.35	117.42	160311.0
2010-03-29 18:30:00	SPY	ETF	117.42	117.42	117.4	117.41	6819.0
2010-03-29 19:00:00	SPY	ETF	117.39	117.42	117.38	117.41	20215.0
2010-03-29 19:30:00	SPY	ETF	117.38	117.38	117.35	117.37	17409.0
2010-03-29 04:30:00	QQQ	ETF	48.29	48.29	48.29	48.29	1000.0
2010-03-29 06:00:00	QQQ	ETF	48.28	48.31	48.28	48.31	11000.0
2010-03-29 06:30:00	QQQ	ETF	48.31	48.31	48.29	48.29	500.0
2010-03-29 07:00:00	QQQ	ETF	48.27	48.3	48.26	48.27	18500.0
2010-03-29 07:30:00	QQQ	ETF	48.28	48.3	48.25	48.25	12500.0
2010-03-29 08:00:00	QQQ	ETF	48.23	48.27	48.21	48.25	134688.0
2010-03-29 08:30:00	QQQ	ETF	48.25	48.27	48.2	48.23	109345.0
2010-03-29 09:00:00	QQQ	ETF	48.22	48.23	48.17	48.22	387655.0
2010-03-29 09:30:00	QQQ	ETF	48.23	48.4	48.21	48.26	8703162.0
2010-03-29 10:00:00	QQQ	ETF	48.27	48.3625	48.24	48.29	5113833.0
2010-03-29 10:30:00	QQQ	ETF	48.28	48.33	48.22	48.29	5421226.0
2010-03-29 11:00:00	QQQ	ETF	48.29	48.4	48.27	48.36	4176960.0
2010-03-29 11:30:00	QQQ	ETF	48.36	48.38	48.32	48.37	1904322.0
2010-03-29 12:00:00	QQQ	ETF	48.3601	48.38	48.275	48.31	1713507.0
2010-03-29 12:30:00	QQQ	ETF	48.305	48.32	48.2	48.2119	1786685.0
2010-03-29 13:00:00	QQQ	ETF	48.21	48.28	48.21	48.21	1544209.0
2010-03-29 13:30:00	QQQ	ETF	48.22	48.245	48.13	48.18	3320919.0
2010-03-29 14:00:00	QQQ	ETF	48.18	48.22	48.1	48.12	3909279.0

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

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