PREVIEW / etf_30min / 2010-06-29

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-29.parquet
  size:    268 KB
  rows:    8,967

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-06-29 04:00:00	SPY	ETF	106.23	106.27	106.08	106.08	12136.0
2010-06-29 04:30:00	SPY	ETF	106.16	106.26	106.16	106.26	600.0
2010-06-29 05:00:00	SPY	ETF	106.24	106.36	106.1	106.13	6875.0
2010-06-29 05:30:00	SPY	ETF	106.2	106.22	106.11	106.17	37700.0
2010-06-29 06:00:00	SPY	ETF	106.31	106.32	106.21	106.26	28900.0
2010-06-29 06:30:00	SPY	ETF	106.26	106.45	106.26	106.4	188150.0
2010-06-29 07:00:00	SPY	ETF	106.4	106.44	106.05	106.15	277834.0
2010-06-29 07:30:00	SPY	ETF	106.13	106.26	106.0	106.2	527415.0
2010-06-29 08:00:00	SPY	ETF	106.2	106.59	106.05	106.23	1302247.0
2010-06-29 08:30:00	SPY	ETF	106.24	106.36	106.12	106.15	940290.0
2010-06-29 09:00:00	SPY	ETF	106.15	106.32	106.01	106.03	2052103.0
2010-06-29 09:30:00	SPY	ETF	106.02	106.07	105.15	105.35	40267902.0
2010-06-29 10:00:00	SPY	ETF	105.46	105.47	104.27	104.32	44209553.0
2010-06-29 10:30:00	SPY	ETF	104.33	104.98	104.3	104.97	26020470.0
2010-06-29 11:00:00	SPY	ETF	104.98	105.72	104.74	104.81	20891411.0
2010-06-29 11:30:00	SPY	ETF	104.81	104.89	104.64	104.67	11727822.0
2010-06-29 12:00:00	SPY	ETF	104.67	104.94	104.43	104.75	18905221.0
2010-06-29 12:30:00	SPY	ETF	104.7401	104.81	104.55	104.64	10003314.0
2010-06-29 13:00:00	SPY	ETF	104.64	104.7	104.32	104.45	12775858.0
2010-06-29 13:30:00	SPY	ETF	104.45	104.64	104.12	104.615	16813818.0
2010-06-29 14:00:00	SPY	ETF	104.61	104.9	104.5	104.75	16407360.0
2010-06-29 14:30:00	SPY	ETF	104.75	104.8	104.33	104.38	20876647.0
2010-06-29 15:00:00	SPY	ETF	104.38	104.71	103.79	103.95	32888350.0
2010-06-29 15:30:00	SPY	ETF	103.95	104.41	103.55	104.22	65135543.0
2010-06-29 16:00:00	SPY	ETF	104.21	106.01	103.91	104.0	19394491.0
2010-06-29 16:30:00	SPY	ETF	104.0	107.5114	103.9	103.93	7051183.0
2010-06-29 17:00:00	SPY	ETF	103.93	103.97	103.81	103.89	318065.0
2010-06-29 17:30:00	SPY	ETF	103.89	104.2	103.87	103.96	196393.0
2010-06-29 18:00:00	SPY	ETF	103.93	104.2	103.79	103.88	232097.0
2010-06-29 18:30:00	SPY	ETF	103.87	104.02	103.86	104.02	84727.0
2010-06-29 19:00:00	SPY	ETF	104.02	104.08	103.98	103.99	71257.0
2010-06-29 19:30:00	SPY	ETF	103.98	104.1	103.89	104.08	74855.0
2010-06-29 04:00:00	QQQ	ETF	44.55	44.55	44.43	44.44	3716.0
2010-06-29 04:30:00	QQQ	ETF	44.45	44.5	44.45	44.45	4895.0
2010-06-29 05:00:00	QQQ	ETF	44.52	44.52	44.49	44.49	15000.0
2010-06-29 05:30:00	QQQ	ETF	44.51	44.51	44.49	44.51	600.0
2010-06-29 06:30:00	QQQ	ETF	44.6	44.6	44.6	44.6	100.0
2010-06-29 07:00:00	QQQ	ETF	44.6	44.6	44.47	44.5	47420.0
2010-06-29 07:30:00	QQQ	ETF	44.48	44.54	44.42	44.53	156808.0
2010-06-29 08:00:00	QQQ	ETF	44.52	44.55	44.49	44.54	195156.0
2010-06-29 08:30:00	QQQ	ETF	44.54	44.58	44.47	44.48	397122.0
2010-06-29 09:00:00	QQQ	ETF	44.48	44.53	44.42	44.42	686964.0
2010-06-29 09:30:00	QQQ	ETF	44.42	44.46	43.81	43.9	16935025.0
2010-06-29 10:00:00	QQQ	ETF	43.9	43.98	43.46	43.47	18639199.0
2010-06-29 10:30:00	QQQ	ETF	43.47	43.83	43.45	43.83	12648715.0
2010-06-29 11:00:00	QQQ	ETF	43.83	43.98	43.74	43.83	7771369.0
2010-06-29 11:30:00	QQQ	ETF	43.82	43.84	43.67	43.7	4061782.0
2010-06-29 12:00:00	QQQ	ETF	43.7	43.83	43.61	43.7201	4597876.0
2010-06-29 12:30:00	QQQ	ETF	43.73	43.73	43.61	43.65	1712320.0
2010-06-29 13:00:00	QQQ	ETF	43.66	43.69	43.55	43.6	2381702.0

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

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