PREVIEW / etf_30min / 2010-09-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-01.parquet
  size:    259 KB
  rows:    8,742

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-09-01 04:00:00	SPY	ETF	105.85	106.5	105.85	105.92	5600.0
2010-09-01 04:30:00	SPY	ETF	106.14	106.66	106.14	106.34	600.0
2010-09-01 05:00:00	SPY	ETF	106.43	106.44	106.41	106.44	300.0
2010-09-01 05:30:00	SPY	ETF	106.46	106.75	106.46	106.6	11018.0
2010-09-01 06:00:00	SPY	ETF	106.55	106.69	106.55	106.56	6925.0
2010-09-01 06:30:00	SPY	ETF	106.58	106.68	106.55	106.67	101780.0
2010-09-01 07:00:00	SPY	ETF	106.66	106.69	106.5	106.52	392847.0
2010-09-01 07:30:00	SPY	ETF	106.54	106.66	106.53	106.57	350623.0
2010-09-01 08:00:00	SPY	ETF	106.56	106.72	105.72	106.71	3757303.0
2010-09-01 08:30:00	SPY	ETF	106.71	106.77	106.62	106.68	1174213.0
2010-09-01 09:00:00	SPY	ETF	106.69	106.8	105.31	106.74	1381712.0
2010-09-01 09:30:00	SPY	ETF	106.73	107.25	106.66	107.14	32015590.0
2010-09-01 10:00:00	SPY	ETF	107.15	108.2	106.94	108.0	46878639.0
2010-09-01 10:30:00	SPY	ETF	107.995	108.39	107.93	108.25	20301618.0
2010-09-01 11:00:00	SPY	ETF	108.25	108.35	108.17	108.24	11089710.0
2010-09-01 11:30:00	SPY	ETF	108.24	108.48	108.23	108.34	12644610.0
2010-09-01 12:00:00	SPY	ETF	108.34	108.39	108.15	108.21	10037561.0
2010-09-01 12:30:00	SPY	ETF	108.2039	108.24	108.13	108.21	6562307.0
2010-09-01 13:00:00	SPY	ETF	108.22	108.32	108.18	108.27	6318092.0
2010-09-01 13:30:00	SPY	ETF	108.26	108.45	108.26	108.36	8850632.0
2010-09-01 14:00:00	SPY	ETF	108.37	108.45	108.08	108.22	14117148.0
2010-09-01 14:30:00	SPY	ETF	108.22	108.26	108.08	108.1701	11479281.0
2010-09-01 15:00:00	SPY	ETF	108.1783	108.35	108.06	108.2	14381258.0
2010-09-01 15:30:00	SPY	ETF	108.2	108.61	108.13	108.47	36349647.0
2010-09-01 16:00:00	SPY	ETF	108.47	108.78	106.745	108.67	11176922.0
2010-09-01 16:30:00	SPY	ETF	108.68	108.69	108.3284	108.66	9304395.0
2010-09-01 17:00:00	SPY	ETF	108.65	108.73	108.59	108.61	4253537.0
2010-09-01 17:30:00	SPY	ETF	108.63	108.65	108.58	108.59	27169.0
2010-09-01 18:00:00	SPY	ETF	108.59	108.68	108.57	108.62	122996.0
2010-09-01 18:30:00	SPY	ETF	108.62	108.62	108.59	108.61	39850.0
2010-09-01 19:00:00	SPY	ETF	108.6	108.63	108.44	108.62	32701.0
2010-09-01 19:30:00	SPY	ETF	108.63	108.77	108.58	108.68	76142.0
2010-09-01 05:00:00	QQQ	ETF	43.95	43.95	43.93	43.93	11835.0
2010-09-01 05:30:00	QQQ	ETF	44.05	44.15	44.05	44.09	16450.0
2010-09-01 06:00:00	QQQ	ETF	44.08	44.09	44.05	44.05	2100.0
2010-09-01 06:30:00	QQQ	ETF	44.05	44.09	44.05	44.08	15499.0
2010-09-01 07:00:00	QQQ	ETF	44.09	44.1	44.02	44.02	113239.0
2010-09-01 07:30:00	QQQ	ETF	44.04	44.09	44.03	44.08	42002.0
2010-09-01 08:00:00	QQQ	ETF	44.05	44.13	43.95	44.11	853571.0
2010-09-01 08:30:00	QQQ	ETF	44.12	44.14	44.06	44.07	400115.0
2010-09-01 09:00:00	QQQ	ETF	44.09	44.12	44.07	44.11	376379.0
2010-09-01 09:30:00	QQQ	ETF	44.1	44.38	44.07	44.29	13980131.0
2010-09-01 10:00:00	QQQ	ETF	44.29	44.72	44.25	44.71	18545178.0
2010-09-01 10:30:00	QQQ	ETF	44.71	44.91	44.68	44.83	6466417.0
2010-09-01 11:00:00	QQQ	ETF	44.82	44.9	44.8	44.84	3240589.0
2010-09-01 11:30:00	QQQ	ETF	44.84	44.91	44.82	44.82	2738611.0
2010-09-01 12:00:00	QQQ	ETF	44.825	44.85	44.75	44.78	1997863.0
2010-09-01 12:30:00	QQQ	ETF	44.78	44.79	44.72	44.735	3505061.0
2010-09-01 13:00:00	QQQ	ETF	44.74	44.81	44.69	44.76	1917819.0
2010-09-01 13:30:00	QQQ	ETF	44.763	44.82	44.73	44.76	1778034.0

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

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