PREVIEW / etf_30min / 2010-09-27

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-27.parquet
  size:    254 KB
  rows:    8,613

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-09-27 04:00:00	SPY	ETF	114.95	114.95	114.88	114.88	1200.0
2010-09-27 04:30:00	SPY	ETF	114.85	114.85	114.75	114.75	400.0
2010-09-27 05:00:00	SPY	ETF	114.79	114.81	114.79	114.79	4600.0
2010-09-27 06:00:00	SPY	ETF	114.92	114.92	114.73	114.73	1400.0
2010-09-27 06:30:00	SPY	ETF	114.77	114.84	114.77	114.84	200.0
2010-09-27 07:00:00	SPY	ETF	114.86	114.91	114.8	114.87	43100.0
2010-09-27 07:30:00	SPY	ETF	114.9	114.94	114.8	114.84	137002.0
2010-09-27 08:00:00	SPY	ETF	114.86	114.96	114.78	114.79	1180725.0
2010-09-27 08:30:00	SPY	ETF	114.78	114.95	114.77	114.94	340800.0
2010-09-27 09:00:00	SPY	ETF	114.95	115.04	114.86	114.87	716440.0
2010-09-27 09:30:00	SPY	ETF	114.86	114.87	114.41	114.5	19217387.0
2010-09-27 10:00:00	SPY	ETF	114.5	114.75	114.38	114.72	9411077.0
2010-09-27 10:30:00	SPY	ETF	114.72	114.81	114.54	114.725	8256991.0
2010-09-27 11:00:00	SPY	ETF	114.72	114.725	114.31	114.45	10478570.0
2010-09-27 11:30:00	SPY	ETF	114.44	114.53	114.32	114.42	6752147.0
2010-09-27 12:00:00	SPY	ETF	114.4262	114.54	114.37	114.48	4628592.0
2010-09-27 12:30:00	SPY	ETF	114.49	114.5	114.39	114.4399	2649291.0
2010-09-27 13:00:00	SPY	ETF	114.44	114.56	114.32	114.51	6255469.0
2010-09-27 13:30:00	SPY	ETF	114.51	114.84	114.47	114.76	7296457.0
2010-09-27 14:00:00	SPY	ETF	114.76	114.88	114.42	114.879	5801087.0
2010-09-27 14:30:00	SPY	ETF	114.88	114.99	114.78	114.81	7817404.0
2010-09-27 15:00:00	SPY	ETF	114.81	114.81	114.7	114.71	8629697.0
2010-09-27 15:30:00	SPY	ETF	114.715	114.72	114.16	114.29	18711082.0
2010-09-27 16:00:00	SPY	ETF	114.29	114.735	114.17	114.18	5511712.0
2010-09-27 16:30:00	SPY	ETF	114.23	114.31	114.1954	114.29	376213.0
2010-09-27 17:00:00	SPY	ETF	114.31	114.36	114.3	114.33	83200.0
2010-09-27 17:30:00	SPY	ETF	114.33	114.33	114.24	114.24	74775.0
2010-09-27 18:00:00	SPY	ETF	114.27	114.33	114.23	114.23	167200.0
2010-09-27 18:30:00	SPY	ETF	114.23	114.23	114.21	114.23	38050.0
2010-09-27 19:00:00	SPY	ETF	114.23	114.23	114.21	114.21	13740.0
2010-09-27 19:30:00	SPY	ETF	114.21	114.24	114.21	114.23	24814.0
2010-09-27 04:00:00	QQQ	ETF	49.79	49.79	49.66	49.66	400.0
2010-09-27 06:30:00	QQQ	ETF	49.64	49.64	49.64	49.64	200.0
2010-09-27 07:00:00	QQQ	ETF	49.67	49.68	49.65	49.68	19446.0
2010-09-27 07:30:00	QQQ	ETF	49.67	49.67	49.63	49.66	73840.0
2010-09-27 08:00:00	QQQ	ETF	49.66	49.69	49.64	49.64	107763.0
2010-09-27 08:30:00	QQQ	ETF	49.63	49.7	49.63	49.7	92350.0
2010-09-27 09:00:00	QQQ	ETF	49.7	49.75	49.64	49.65	207769.0
2010-09-27 09:30:00	QQQ	ETF	49.65	49.67	49.47	49.51	6117745.0
2010-09-27 10:00:00	QQQ	ETF	49.5125	49.61	49.46	49.59	3786356.0
2010-09-27 10:30:00	QQQ	ETF	49.59	49.65	49.51	49.5677	3782944.0
2010-09-27 11:00:00	QQQ	ETF	49.57	49.57	49.4	49.45	3653528.0
2010-09-27 11:30:00	QQQ	ETF	49.4568	49.51	49.4	49.47	4048017.0
2010-09-27 12:00:00	QQQ	ETF	49.48	49.53	49.44	49.5	2005705.0
2010-09-27 12:30:00	QQQ	ETF	49.49	49.51	49.44	49.47	1227393.0
2010-09-27 13:00:00	QQQ	ETF	49.475	49.56	49.44	49.51	1462884.0
2010-09-27 13:30:00	QQQ	ETF	49.51	49.68	49.5	49.6501	3323833.0
2010-09-27 14:00:00	QQQ	ETF	49.65	49.72	49.62	49.72	2366658.0
2010-09-27 14:30:00	QQQ	ETF	49.72	49.75	49.64	49.64	1751776.0
2010-09-27 15:00:00	QQQ	ETF	49.64	49.65	49.6	49.619	1137607.0

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

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