PREVIEW / etf_30min / 2010-08-05

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-05.parquet
  size:    242 KB
  rows:    8,125

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-08-05 04:00:00	SPY	ETF	112.88	112.88	112.77	112.78	2900.0
2010-08-05 04:30:00	SPY	ETF	112.95	112.95	112.95	112.95	100.0
2010-08-05 05:30:00	SPY	ETF	112.97	113.0	112.97	113.0	700.0
2010-08-05 06:00:00	SPY	ETF	113.07	113.1	113.07	113.08	8900.0
2010-08-05 06:30:00	SPY	ETF	113.11	113.25	113.11	113.24	11400.0
2010-08-05 07:00:00	SPY	ETF	113.24	113.3	113.08	113.08	582870.0
2010-08-05 07:30:00	SPY	ETF	113.12	113.12	112.95	112.98	325712.0
2010-08-05 08:00:00	SPY	ETF	112.99	113.27	112.78	113.0	1998747.0
2010-08-05 08:30:00	SPY	ETF	112.83	113.0	112.36	112.45	4052425.0
2010-08-05 09:00:00	SPY	ETF	112.45	112.47	112.21	112.24	2097867.0
2010-08-05 09:30:00	SPY	ETF	112.25	112.64	112.08	112.5	25669911.0
2010-08-05 10:00:00	SPY	ETF	112.5	112.73	112.42	112.729	12842186.0
2010-08-05 10:30:00	SPY	ETF	112.725	112.78	112.28	112.32	9820179.0
2010-08-05 11:00:00	SPY	ETF	112.32	112.51	112.16	112.468	9349339.0
2010-08-05 11:30:00	SPY	ETF	112.47	112.61	112.33	112.44	8550249.0
2010-08-05 12:00:00	SPY	ETF	112.4301	112.62	112.4	112.53	4768029.0
2010-08-05 12:30:00	SPY	ETF	112.54	112.58	112.42	112.465	4026728.0
2010-08-05 13:00:00	SPY	ETF	112.46	112.515	112.31	112.5	4216451.0
2010-08-05 13:30:00	SPY	ETF	112.5	112.74	112.5	112.669	4850015.0
2010-08-05 14:00:00	SPY	ETF	112.67	112.73	112.55	112.655	4803210.0
2010-08-05 14:30:00	SPY	ETF	112.655	112.73	112.59	112.65	5515117.0
2010-08-05 15:00:00	SPY	ETF	112.659	112.91	112.6476	112.76	8586871.0
2010-08-05 15:30:00	SPY	ETF	112.76	112.84	112.61	112.84	16052037.0
2010-08-05 16:00:00	SPY	ETF	112.85	112.93	112.295	112.83	8353318.0
2010-08-05 16:30:00	SPY	ETF	112.84	112.98	112.84	112.95	400069.0
2010-08-05 17:00:00	SPY	ETF	112.96	112.98	112.94	112.96	161392.0
2010-08-05 17:30:00	SPY	ETF	112.95	112.97	112.91	112.95	30675.0
2010-08-05 18:00:00	SPY	ETF	112.96	112.96	112.92	112.93	21137.0
2010-08-05 18:30:00	SPY	ETF	112.92	112.93	112.85	112.9	35359.0
2010-08-05 19:00:00	SPY	ETF	112.91	112.91	112.87	112.88	36960.0
2010-08-05 19:30:00	SPY	ETF	112.88	112.91	112.87	112.87	22305.0
2010-08-05 05:00:00	QQQ	ETF	46.94	46.94	46.94	46.94	200.0
2010-08-05 05:30:00	QQQ	ETF	46.94	46.96	46.94	46.96	2482.0
2010-08-05 06:30:00	QQQ	ETF	47.0	47.03	47.0	47.02	770.0
2010-08-05 07:00:00	QQQ	ETF	47.03	47.04	46.95	46.96	9200.0
2010-08-05 07:30:00	QQQ	ETF	46.95	46.95	46.9	46.91	7363.0
2010-08-05 08:00:00	QQQ	ETF	46.89	46.96	46.84	46.92	1688539.0
2010-08-05 08:30:00	QQQ	ETF	46.91	46.91	46.75	46.77	1071211.0
2010-08-05 09:00:00	QQQ	ETF	46.78	46.78	46.7	46.72	511614.0
2010-08-05 09:30:00	QQQ	ETF	46.72	46.905	46.64	46.81	6983240.0
2010-08-05 10:00:00	QQQ	ETF	46.81	46.89	46.76	46.89	2423107.0
2010-08-05 10:30:00	QQQ	ETF	46.8801	46.92	46.63	46.6405	3332371.0
2010-08-05 11:00:00	QQQ	ETF	46.65	46.72	46.52	46.71	4604690.0
2010-08-05 11:30:00	QQQ	ETF	46.71	46.78	46.63	46.71	2084508.0
2010-08-05 12:00:00	QQQ	ETF	46.7138	46.8	46.7	46.74	2031440.0
2010-08-05 12:30:00	QQQ	ETF	46.74	46.78	46.7	46.74	891100.0
2010-08-05 13:00:00	QQQ	ETF	46.74	46.76	46.66	46.75	914560.0
2010-08-05 13:30:00	QQQ	ETF	46.75	46.89	46.75	46.87	1347649.0
2010-08-05 14:00:00	QQQ	ETF	46.87	46.88	46.82	46.84	1049936.0
2010-08-05 14:30:00	QQQ	ETF	46.85	46.88	46.8	46.8219	1742390.0

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

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