PREVIEW / etf_30min / 2010-04-07

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-07.parquet
  size:    252 KB
  rows:    8,347

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-04-07 04:00:00	SPY	ETF	118.71	118.72	118.65	118.68	1050.0
2010-04-07 04:30:00	SPY	ETF	118.66	118.66	118.66	118.66	700.0
2010-04-07 05:00:00	SPY	ETF	118.85	118.85	118.85	118.85	200.0
2010-04-07 05:30:00	SPY	ETF	118.86	118.86	118.81	118.84	3000.0
2010-04-07 06:00:00	SPY	ETF	118.81	118.84	118.78	118.78	6700.0
2010-04-07 06:30:00	SPY	ETF	118.84	118.85	118.73	118.73	10660.0
2010-04-07 07:00:00	SPY	ETF	118.73	118.75	118.69	118.75	27750.0
2010-04-07 07:30:00	SPY	ETF	118.72	118.73	118.63	118.63	154291.0
2010-04-07 08:00:00	SPY	ETF	118.65	118.7	118.46	118.54	862042.0
2010-04-07 08:30:00	SPY	ETF	118.54	118.69	118.5	118.67	485806.0
2010-04-07 09:00:00	SPY	ETF	118.67	118.8	118.65	118.8	1172295.0
2010-04-07 09:30:00	SPY	ETF	118.8	118.97	118.62	118.81	18508073.0
2010-04-07 10:00:00	SPY	ETF	118.81	118.94	118.68	118.83	10400942.0
2010-04-07 10:30:00	SPY	ETF	118.83	118.89	118.38	118.51	17327513.0
2010-04-07 11:00:00	SPY	ETF	118.51	118.82	118.36	118.78	14403375.0
2010-04-07 11:30:00	SPY	ETF	118.78	118.82	118.5	118.74	6766331.0
2010-04-07 12:00:00	SPY	ETF	118.74	119.3567	118.64	118.65	5003410.0
2010-04-07 12:30:00	SPY	ETF	118.65	118.8	118.63	118.8	3361206.0
2010-04-07 13:00:00	SPY	ETF	118.8	119.08	118.78	119.02	11473829.0
2010-04-07 13:30:00	SPY	ETF	119.01	119.03	118.78	118.91	6928040.0
2010-04-07 14:00:00	SPY	ETF	118.92	118.92	118.53	118.59	9422084.0
2010-04-07 14:30:00	SPY	ETF	118.59	118.61	118.34	118.43	13654567.0
2010-04-07 15:00:00	SPY	ETF	118.42	118.43	117.81	118.065	28609355.0
2010-04-07 15:30:00	SPY	ETF	118.07	118.39	117.98	118.38	19105366.0
2010-04-07 16:00:00	SPY	ETF	118.38	118.96	118.0	118.36	9157128.0
2010-04-07 16:30:00	SPY	ETF	118.35	118.38	118.3	118.36	1195545.0
2010-04-07 17:00:00	SPY	ETF	118.37	119.0471	118.29	118.3	1157333.0
2010-04-07 17:30:00	SPY	ETF	118.29	118.36	118.29	118.35	10353.0
2010-04-07 18:00:00	SPY	ETF	118.33	118.36	118.3	118.33	40606.0
2010-04-07 18:30:00	SPY	ETF	118.33	118.37	118.3	118.3	17504.0
2010-04-07 19:00:00	SPY	ETF	118.3	118.3	118.22	118.24	58164.0
2010-04-07 19:30:00	SPY	ETF	118.22	118.24	118.2	118.21	35014.0
2010-04-07 07:00:00	QQQ	ETF	48.64	48.64	48.64	48.64	400.0
2010-04-07 07:30:00	QQQ	ETF	48.61	48.63	48.6	48.62	21660.0
2010-04-07 08:00:00	QQQ	ETF	48.62	48.64	48.57	48.58	139466.0
2010-04-07 08:30:00	QQQ	ETF	48.55	48.64	48.55	48.63	182362.0
2010-04-07 09:00:00	QQQ	ETF	48.63	48.7	48.63	48.68	157881.0
2010-04-07 09:30:00	QQQ	ETF	48.69	48.77	48.6	48.69	9756551.0
2010-04-07 10:00:00	QQQ	ETF	48.69	48.81	48.65	48.76	6275800.0
2010-04-07 10:30:00	QQQ	ETF	48.76	48.858	48.59	48.67	6670486.0
2010-04-07 11:00:00	QQQ	ETF	48.67	48.79	48.61	48.7601	5318297.0
2010-04-07 11:30:00	QQQ	ETF	48.77	48.79	48.7	48.76	2240814.0
2010-04-07 12:00:00	QQQ	ETF	48.76	48.79	48.72	48.72	1194632.0
2010-04-07 12:30:00	QQQ	ETF	48.72	48.79	48.71	48.79	1155117.0
2010-04-07 13:00:00	QQQ	ETF	48.79	48.87	48.78	48.85	5168038.0
2010-04-07 13:30:00	QQQ	ETF	48.85	48.86	48.74	48.8	2064990.0
2010-04-07 14:00:00	QQQ	ETF	48.81	48.82	48.66	48.69	3270493.0
2010-04-07 14:30:00	QQQ	ETF	48.69	48.71	48.59	48.631	4522382.0
2010-04-07 15:00:00	QQQ	ETF	48.63	48.63	48.37	48.489	12831714.0
2010-04-07 15:30:00	QQQ	ETF	48.4872	48.64	48.45	48.64	5371158.0

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

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