PREVIEW / etf_30min / 2010-06-07

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-07.parquet
  size:    265 KB
  rows:    8,708

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-07 04:00:00	SPY	ETF	106.57	106.67	106.57	106.67	1674.0
2010-06-07 04:30:00	SPY	ETF	106.61	106.83	106.6	106.81	1800.0
2010-06-07 05:00:00	SPY	ETF	106.65	106.78	106.65	106.73	11072.0
2010-06-07 05:30:00	SPY	ETF	106.85	107.0	106.79	107.0	3100.0
2010-06-07 06:00:00	SPY	ETF	107.12	107.3	106.99	107.19	17082.0
2010-06-07 06:30:00	SPY	ETF	107.25	107.35	107.23	107.25	28100.0
2010-06-07 07:00:00	SPY	ETF	107.26	107.45	107.25	107.39	483483.0
2010-06-07 07:30:00	SPY	ETF	107.41	107.5	107.2	107.26	546777.0
2010-06-07 08:00:00	SPY	ETF	107.26	107.55	106.2375	107.48	2636826.0
2010-06-07 08:30:00	SPY	ETF	107.48	107.59	107.27	107.3	1792298.0
2010-06-07 09:00:00	SPY	ETF	107.3	107.43	106.96	107.21	2391399.0
2010-06-07 09:30:00	SPY	ETF	107.2	107.4	106.57	107.27	33883256.0
2010-06-07 10:00:00	SPY	ETF	107.27	107.61	107.13	107.32	17551779.0
2010-06-07 10:30:00	SPY	ETF	107.32	107.35	106.35	106.42	23532663.0
2010-06-07 11:00:00	SPY	ETF	106.42	107.0	106.28	106.66	16140510.0
2010-06-07 11:30:00	SPY	ETF	106.67	107.03	106.6	107.0	13665038.0
2010-06-07 12:00:00	SPY	ETF	107.0	107.28	106.9	106.9299	11745277.0
2010-06-07 12:30:00	SPY	ETF	106.92	107.21	106.89	107.13	7642135.0
2010-06-07 13:00:00	SPY	ETF	107.12	107.32	106.94	107.31	6588673.0
2010-06-07 13:30:00	SPY	ETF	107.31	107.37	106.67	106.82	9612391.0
2010-06-07 14:00:00	SPY	ETF	106.815	106.95	106.5	106.71	9147495.0
2010-06-07 14:30:00	SPY	ETF	106.72	106.82	106.13	106.32	14373022.0
2010-06-07 15:00:00	SPY	ETF	106.32	106.69	105.67	105.68	26960631.0
2010-06-07 15:30:00	SPY	ETF	105.68	105.99	105.41	105.5	39838044.0
2010-06-07 16:00:00	SPY	ETF	105.49	107.58	105.22	105.36	13108528.0
2010-06-07 16:30:00	SPY	ETF	105.35	105.48	105.27	105.48	1465961.0
2010-06-07 17:00:00	SPY	ETF	105.48	106.9384	105.4	105.45	1200626.0
2010-06-07 17:30:00	SPY	ETF	105.44	105.49	105.41	105.44	85636.0
2010-06-07 18:00:00	SPY	ETF	105.44	105.47	105.29	105.42	67323.0
2010-06-07 18:30:00	SPY	ETF	105.42	105.49	105.39	105.45	25156.0
2010-06-07 19:00:00	SPY	ETF	105.45	105.63	105.45	105.63	84477.0
2010-06-07 19:30:00	SPY	ETF	105.62	105.73	105.6	105.7	132832.0
2010-06-07 04:00:00	QQQ	ETF	44.92	45.01	44.92	45.01	1700.0
2010-06-07 04:30:00	QQQ	ETF	45.07	45.1	45.05	45.1	4000.0
2010-06-07 05:00:00	QQQ	ETF	45.09	45.09	45.09	45.09	2000.0
2010-06-07 05:30:00	QQQ	ETF	45.23	45.23	45.23	45.23	1000.0
2010-06-07 06:00:00	QQQ	ETF	45.27	45.27	45.27	45.27	100.0
2010-06-07 06:30:00	QQQ	ETF	45.28	45.28	45.26	45.27	2700.0
2010-06-07 07:00:00	QQQ	ETF	45.26	45.35	45.26	45.33	431868.0
2010-06-07 07:30:00	QQQ	ETF	45.32	45.36	45.26	45.27	272190.0
2010-06-07 08:00:00	QQQ	ETF	45.28	45.43	45.23	45.42	2481347.0
2010-06-07 08:30:00	QQQ	ETF	45.41	45.45	45.3	45.33	230923.0
2010-06-07 09:00:00	QQQ	ETF	45.34	45.38	45.21	45.34	941670.0
2010-06-07 09:30:00	QQQ	ETF	45.35	45.42	44.99	45.34	13773070.0
2010-06-07 10:00:00	QQQ	ETF	45.34	45.46	45.2	45.23	6350873.0
2010-06-07 10:30:00	QQQ	ETF	45.235	45.25	44.67	44.7	7669909.0
2010-06-07 11:00:00	QQQ	ETF	44.71	44.82	44.6199	44.76	5698269.0
2010-06-07 11:30:00	QQQ	ETF	44.75	44.95	44.75	44.95	2411753.0
2010-06-07 12:00:00	QQQ	ETF	44.94	45.05	44.88	44.89	2498599.0
2010-06-07 12:30:00	QQQ	ETF	44.89	45.08	44.87	45.0399	1221510.0

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

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