PREVIEW / etf_30min / 2010-03-05

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-05.parquet
  size:    251 KB
  rows:    8,387

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-05 04:30:00	SPY	ETF	112.9	112.9	112.89	112.89	200.0
2010-03-05 05:00:00	SPY	ETF	112.89	112.95	112.89	112.95	27250.0
2010-03-05 05:30:00	SPY	ETF	113.0	113.24	113.0	113.24	6000.0
2010-03-05 06:00:00	SPY	ETF	113.18	113.18	113.13	113.14	650.0
2010-03-05 06:30:00	SPY	ETF	113.13	113.14	113.1	113.1	28325.0
2010-03-05 07:00:00	SPY	ETF	113.1	113.3	113.1	113.22	54908.0
2010-03-05 07:30:00	SPY	ETF	113.24	113.31	113.17	113.17	213065.0
2010-03-05 08:00:00	SPY	ETF	113.17	113.39	113.02	113.25	2056319.0
2010-03-05 08:30:00	SPY	ETF	113.16	113.61	113.16	113.36	4749485.0
2010-03-05 09:00:00	SPY	ETF	113.37	113.44	113.28	113.38	1315481.0
2010-03-05 09:30:00	SPY	ETF	113.37	113.54	113.1	113.49	21939959.0
2010-03-05 10:00:00	SPY	ETF	113.49	113.92	113.41	113.87	21675901.0
2010-03-05 10:30:00	SPY	ETF	113.87	113.9	113.73	113.81	11550093.0
2010-03-05 11:00:00	SPY	ETF	113.82	113.92	113.79	113.85	11515108.0
2010-03-05 11:30:00	SPY	ETF	113.86	113.86	113.75	113.76	7106721.0
2010-03-05 12:00:00	SPY	ETF	113.76	113.868	113.73	113.8	5094503.0
2010-03-05 12:30:00	SPY	ETF	113.79	113.89	113.77	113.87	4367145.0
2010-03-05 13:00:00	SPY	ETF	113.88	113.95	113.8	113.89	5282849.0
2010-03-05 13:30:00	SPY	ETF	113.8984	113.93	113.79	113.89	6430384.0
2010-03-05 14:00:00	SPY	ETF	113.89	113.97	113.81	113.89	6785498.0
2010-03-05 14:30:00	SPY	ETF	113.8984	114.16	113.88	114.15	15166047.0
2010-03-05 15:00:00	SPY	ETF	114.145	114.34	114.02	114.12	18744816.0
2010-03-05 15:30:00	SPY	ETF	114.12	114.27	114.1	114.26	22281971.0
2010-03-05 16:00:00	SPY	ETF	114.25	114.26	113.18	114.1	7395119.0
2010-03-05 16:30:00	SPY	ETF	114.1	114.23	114.07	114.09	1273475.0
2010-03-05 17:00:00	SPY	ETF	114.1	114.23	114.09	114.14	126329.0
2010-03-05 17:30:00	SPY	ETF	114.15	114.1955	114.13	114.14	99985.0
2010-03-05 18:00:00	SPY	ETF	114.14	114.23	114.1	114.1	10959.0
2010-03-05 18:30:00	SPY	ETF	114.11	114.18	114.08	114.14	29998.0
2010-03-05 19:00:00	SPY	ETF	114.14	114.18	114.14	114.15	3900.0
2010-03-05 19:30:00	SPY	ETF	114.16	114.18	114.14	114.16	26870.0
2010-03-05 04:00:00	QQQ	ETF	45.84	45.84	45.84	45.84	797.0
2010-03-05 04:30:00	QQQ	ETF	45.85	45.85	45.84	45.84	1600.0
2010-03-05 05:30:00	QQQ	ETF	45.91	45.91	45.91	45.91	400.0
2010-03-05 06:00:00	QQQ	ETF	45.89	45.89	45.88	45.89	8000.0
2010-03-05 07:00:00	QQQ	ETF	45.89	45.93	45.88	45.92	124210.0
2010-03-05 07:30:00	QQQ	ETF	45.93	45.96	45.91	45.94	21195.0
2010-03-05 08:00:00	QQQ	ETF	45.93	46.03	45.88	45.97	1073902.0
2010-03-05 08:30:00	QQQ	ETF	46.0	46.09	45.99	46.04	1965478.0
2010-03-05 09:00:00	QQQ	ETF	46.04	46.11	46.01	46.09	616549.0
2010-03-05 09:30:00	QQQ	ETF	46.1	46.22	45.99	46.2	11244416.0
2010-03-05 10:00:00	QQQ	ETF	46.1999	46.39	46.16	46.36	7744688.0
2010-03-05 10:30:00	QQQ	ETF	46.36	46.39	46.32	46.36	4071226.0
2010-03-05 11:00:00	QQQ	ETF	46.36	46.41	46.34	46.39	3113963.0
2010-03-05 11:30:00	QQQ	ETF	46.39	46.39	46.2865	46.33	2028278.0
2010-03-05 12:00:00	QQQ	ETF	46.3399	46.36	46.31	46.351	2222966.0
2010-03-05 12:30:00	QQQ	ETF	46.35	46.4201	46.33	46.42	2152481.0
2010-03-05 13:00:00	QQQ	ETF	46.43	46.47	46.39	46.42	2229695.0
2010-03-05 13:30:00	QQQ	ETF	46.41	46.43	46.38	46.4065	2005968.0
2010-03-05 14:00:00	QQQ	ETF	46.41	46.44	46.37	46.4	3019379.0

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

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