PREVIEW / etf_30min / 2010-04-05

all etf 30-min files

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

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-05 04:00:00	SPY	ETF	118.0	118.0	118.0	118.0	100.0
2010-04-05 05:00:00	SPY	ETF	118.13	118.13	118.13	118.13	200.0
2010-04-05 05:30:00	SPY	ETF	118.15	118.15	118.11	118.11	200.0
2010-04-05 06:00:00	SPY	ETF	118.15	118.15	118.15	118.15	100.0
2010-04-05 06:30:00	SPY	ETF	118.16	118.16	118.08	118.08	13200.0
2010-04-05 07:00:00	SPY	ETF	118.1	118.36	118.1	118.34	209355.0
2010-04-05 07:30:00	SPY	ETF	118.32	118.33	118.27	118.32	114874.0
2010-04-05 08:00:00	SPY	ETF	118.3	118.35	117.67	118.24	329268.0
2010-04-05 08:30:00	SPY	ETF	118.24	118.25	118.13	118.21	738003.0
2010-04-05 09:00:00	SPY	ETF	118.22	118.31	118.21	118.26	504486.0
2010-04-05 09:30:00	SPY	ETF	118.25	118.42	117.92	118.4	15652321.0
2010-04-05 10:00:00	SPY	ETF	118.38	118.64	117.97	118.53	17287448.0
2010-04-05 10:30:00	SPY	ETF	118.52	118.84	118.38	118.74	9229409.0
2010-04-05 11:00:00	SPY	ETF	118.74	118.82	118.65	118.79	5849929.0
2010-04-05 11:30:00	SPY	ETF	118.79	118.82	118.64	118.78	3969509.0
2010-04-05 12:00:00	SPY	ETF	118.78	118.805	118.7	118.74	3071143.0
2010-04-05 12:30:00	SPY	ETF	118.75	118.82	118.69	118.7101	2992763.0
2010-04-05 13:00:00	SPY	ETF	118.71	118.77	118.64	118.76	3207558.0
2010-04-05 13:30:00	SPY	ETF	118.75	118.8	118.56	118.63	4750320.0
2010-04-05 14:00:00	SPY	ETF	118.63	118.74	118.59	118.71	3327488.0
2010-04-05 14:30:00	SPY	ETF	118.7101	118.84	118.65	118.6799	5985475.0
2010-04-05 15:00:00	SPY	ETF	118.67	118.78	118.62	118.7099	6574336.0
2010-04-05 15:30:00	SPY	ETF	118.71	118.8	118.57	118.78	13977288.0
2010-04-05 16:00:00	SPY	ETF	118.79	118.79	117.97	118.75	2862385.0
2010-04-05 16:30:00	SPY	ETF	118.76	118.82	117.8617	118.8	1204330.0
2010-04-05 17:00:00	SPY	ETF	118.8	118.83	118.8	118.83	70305.0
2010-04-05 17:30:00	SPY	ETF	118.8	118.83	118.79	118.82	36700.0
2010-04-05 18:00:00	SPY	ETF	118.82	118.82	118.78	118.8	34397.0
2010-04-05 18:30:00	SPY	ETF	118.79	118.79	118.76	118.78	12502.0
2010-04-05 19:00:00	SPY	ETF	118.8	118.83	118.77	118.81	71100.0
2010-04-05 19:30:00	SPY	ETF	118.82	118.84	118.76	118.76	108210.0
2010-04-05 05:30:00	QQQ	ETF	48.24	48.24	48.24	48.24	236.0
2010-04-05 06:30:00	QQQ	ETF	48.29	48.29	48.29	48.29	1000.0
2010-04-05 07:00:00	QQQ	ETF	48.27	48.31	48.25	48.3	88400.0
2010-04-05 07:30:00	QQQ	ETF	48.32	48.32	48.3	48.3	2400.0
2010-04-05 08:00:00	QQQ	ETF	48.3	48.33	48.08	48.3	123763.0
2010-04-05 08:30:00	QQQ	ETF	48.3	48.3	48.19	48.28	510211.0
2010-04-05 09:00:00	QQQ	ETF	48.28	48.32	48.25	48.26	297068.0
2010-04-05 09:30:00	QQQ	ETF	48.26	48.54	48.14	48.46	11481395.0
2010-04-05 10:00:00	QQQ	ETF	48.46	48.57	48.41	48.51	6231645.0
2010-04-05 10:30:00	QQQ	ETF	48.51	48.72	48.5	48.67	4883626.0
2010-04-05 11:00:00	QQQ	ETF	48.67	48.685	48.62	48.65	4011296.0
2010-04-05 11:30:00	QQQ	ETF	48.65	48.65	48.59	48.615	2511334.0
2010-04-05 12:00:00	QQQ	ETF	48.62	48.6425	48.58	48.63	1766269.0
2010-04-05 12:30:00	QQQ	ETF	48.625	48.66	48.62	48.63	1391068.0
2010-04-05 13:00:00	QQQ	ETF	48.62	48.65	48.58	48.62	1284361.0
2010-04-05 13:30:00	QQQ	ETF	48.63	48.65	48.55	48.57	1387959.0
2010-04-05 14:00:00	QQQ	ETF	48.57	48.62	48.55	48.59	1103544.0
2010-04-05 14:30:00	QQQ	ETF	48.6	48.67	48.58	48.59	2865741.0
2010-04-05 15:00:00	QQQ	ETF	48.6	48.63	48.56	48.6	1513769.0

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

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