PREVIEW / etf_30min / 2010-07-15

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-15.parquet
  size:    251 KB
  rows:    8,227

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-07-15 04:00:00	SPY	ETF	109.38	109.44	109.3	109.44	1728.0
2010-07-15 04:30:00	SPY	ETF	109.55	109.78	109.52	109.67	4155.0
2010-07-15 05:00:00	SPY	ETF	109.68	109.68	109.68	109.68	200.0
2010-07-15 05:30:00	SPY	ETF	109.6	109.6	109.6	109.6	2000.0
2010-07-15 06:00:00	SPY	ETF	109.62	110.06	109.62	109.93	129600.0
2010-07-15 06:30:00	SPY	ETF	109.94	110.08	109.82	110.08	132650.0
2010-07-15 07:00:00	SPY	ETF	110.03	110.08	109.86	109.92	987370.0
2010-07-15 07:30:00	SPY	ETF	109.92	110.05	109.85	109.97	372498.0
2010-07-15 08:00:00	SPY	ETF	110.25	110.3	109.91	110.17	2368218.0
2010-07-15 08:30:00	SPY	ETF	110.14	110.44	109.66	109.7	4394193.0
2010-07-15 09:00:00	SPY	ETF	109.71	109.94	109.58	109.61	1334920.0
2010-07-15 09:30:00	SPY	ETF	109.61	109.69	109.19	109.4	21988436.0
2010-07-15 10:00:00	SPY	ETF	109.4	109.47	108.17	108.51	33196893.0
2010-07-15 10:30:00	SPY	ETF	108.51	108.7	108.37	108.6	14528862.0
2010-07-15 11:00:00	SPY	ETF	108.6	108.81	108.4	108.79	12064221.0
2010-07-15 11:30:00	SPY	ETF	108.79	108.85	108.61	108.63	8797336.0
2010-07-15 12:00:00	SPY	ETF	108.63	108.71	108.45	108.51	7209872.0
2010-07-15 12:30:00	SPY	ETF	108.51	108.73	108.44	108.63	4294488.0
2010-07-15 13:00:00	SPY	ETF	108.63	109.25	108.63	109.135	10957639.0
2010-07-15 13:30:00	SPY	ETF	109.14	109.24	108.97	109.05	7861241.0
2010-07-15 14:00:00	SPY	ETF	109.04	109.29	108.88	109.26	11747491.0
2010-07-15 14:30:00	SPY	ETF	109.26	109.6667	109.09	109.125	9679304.0
2010-07-15 15:00:00	SPY	ETF	109.125	109.22	108.64	109.03	20604212.0
2010-07-15 15:30:00	SPY	ETF	109.05	110.06	108.8273	109.72	44534134.0
2010-07-15 16:00:00	SPY	ETF	109.72	109.92	108.1757	109.6	12095192.0
2010-07-15 16:30:00	SPY	ETF	109.58	109.98	109.0217	109.82	1281876.0
2010-07-15 17:00:00	SPY	ETF	109.82	109.93	109.81	109.9	216617.0
2010-07-15 17:30:00	SPY	ETF	109.9	109.99	109.9	109.95	136810.0
2010-07-15 18:00:00	SPY	ETF	109.94	109.96	109.68	109.95	457044.0
2010-07-15 18:30:00	SPY	ETF	109.94	109.96	109.89	109.93	194228.0
2010-07-15 19:00:00	SPY	ETF	109.91	109.93	109.86	109.89	30550.0
2010-07-15 19:30:00	SPY	ETF	109.9	109.95	109.89	109.91	51233.0
2010-07-15 04:30:00	QQQ	ETF	45.64	45.64	45.64	45.64	2700.0
2010-07-15 06:00:00	QQQ	ETF	45.6	45.75	45.6	45.75	1600.0
2010-07-15 06:30:00	QQQ	ETF	45.79	45.79	45.72	45.79	22082.0
2010-07-15 07:00:00	QQQ	ETF	45.75	45.78	45.71	45.75	138295.0
2010-07-15 07:30:00	QQQ	ETF	45.72	45.75	45.7	45.71	86700.0
2010-07-15 08:00:00	QQQ	ETF	45.7	45.81	45.7	45.75	234412.0
2010-07-15 08:30:00	QQQ	ETF	45.77	45.88	45.57	45.58	1004991.0
2010-07-15 09:00:00	QQQ	ETF	45.59	45.67	45.46	45.47	1029901.0
2010-07-15 09:30:00	QQQ	ETF	45.47	45.54	45.33	45.51	11145668.0
2010-07-15 10:00:00	QQQ	ETF	45.51	45.5199	44.99	45.13	13601441.0
2010-07-15 10:30:00	QQQ	ETF	45.13	45.19	45.06	45.17	6056892.0
2010-07-15 11:00:00	QQQ	ETF	45.18	45.29	45.07	45.27	2989212.0
2010-07-15 11:30:00	QQQ	ETF	45.26	45.33	45.19	45.24	3541474.0
2010-07-15 12:00:00	QQQ	ETF	45.2306	45.29	45.18	45.19	1453274.0
2010-07-15 12:30:00	QQQ	ETF	45.185	45.26	45.115	45.2	2018329.0
2010-07-15 13:00:00	QQQ	ETF	45.21	45.44	45.21	45.38	3177168.0
2010-07-15 13:30:00	QQQ	ETF	45.38	45.43	45.32	45.34	3071165.0
2010-07-15 14:00:00	QQQ	ETF	45.34	45.47	45.28	45.45	2863224.0

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

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