PREVIEW / etf_30min / 2010-11-17

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-17.parquet
  size:    262 KB
  rows:    8,863

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-11-17 04:00:00	SPY	ETF	118.22	118.5	118.22	118.42	3815.0
2010-11-17 04:30:00	SPY	ETF	118.41	118.45	118.37	118.4	13800.0
2010-11-17 05:00:00	SPY	ETF	118.37	118.45	118.37	118.45	20200.0
2010-11-17 05:30:00	SPY	ETF	118.42	118.6	118.42	118.58	1675.0
2010-11-17 06:00:00	SPY	ETF	118.53	118.6	118.29	118.32	18300.0
2010-11-17 06:30:00	SPY	ETF	118.33	118.33	118.2	118.2	118073.0
2010-11-17 07:00:00	SPY	ETF	118.2	118.25	118.02	118.05	394892.0
2010-11-17 07:30:00	SPY	ETF	118.05	118.46	118.02	118.33	343650.0
2010-11-17 08:00:00	SPY	ETF	118.33	118.47	118.2	118.27	986325.0
2010-11-17 08:30:00	SPY	ETF	118.28	118.55	118.12	118.23	3230841.0
2010-11-17 09:00:00	SPY	ETF	118.22	118.35	118.1	118.21	1126934.0
2010-11-17 09:30:00	SPY	ETF	118.21	118.37	117.86	118.29	21669771.0
2010-11-17 10:00:00	SPY	ETF	118.3	118.68	118.29	118.615	14400344.0
2010-11-17 10:30:00	SPY	ETF	118.62	118.71	118.3	118.38	14286362.0
2010-11-17 11:00:00	SPY	ETF	118.38	118.59	118.25	118.54	11113305.0
2010-11-17 11:30:00	SPY	ETF	118.53	118.62	118.29	118.54	9686707.0
2010-11-17 12:00:00	SPY	ETF	118.53	118.62	118.36	118.44	4471643.0
2010-11-17 12:30:00	SPY	ETF	118.44	118.5	118.36	118.4	4156102.0
2010-11-17 13:00:00	SPY	ETF	118.39	118.57	118.32	118.56	5882870.0
2010-11-17 13:30:00	SPY	ETF	118.56	118.65	118.34	118.47	6742528.0
2010-11-17 14:00:00	SPY	ETF	118.48	118.55	118.32	118.42	9659783.0
2010-11-17 14:30:00	SPY	ETF	118.43	118.55	118.34	118.4	6541715.0
2010-11-17 15:00:00	SPY	ETF	118.4	118.43	117.89	117.93	21851265.0
2010-11-17 15:30:00	SPY	ETF	117.93	118.34	117.9	118.22	25415153.0
2010-11-17 16:00:00	SPY	ETF	118.21	118.495	118.17	118.3	6754232.0
2010-11-17 16:30:00	SPY	ETF	118.28	118.3739	118.2	118.22	1441407.0
2010-11-17 17:00:00	SPY	ETF	118.22	118.24	118.2	118.24	196419.0
2010-11-17 17:30:00	SPY	ETF	118.23	118.28	118.18	118.28	65066.0
2010-11-17 18:00:00	SPY	ETF	118.28	118.39	118.21	118.36	103440.0
2010-11-17 18:30:00	SPY	ETF	118.38	118.45	118.38	118.45	48650.0
2010-11-17 19:00:00	SPY	ETF	118.44	118.46	118.42	118.45	40313.0
2010-11-17 19:30:00	SPY	ETF	118.46	118.63	118.46	118.6	102626.0
2010-11-17 04:00:00	QQQ	ETF	51.54	51.54	51.54	51.54	100.0
2010-11-17 05:00:00	QQQ	ETF	51.62	51.62	51.62	51.62	2000.0
2010-11-17 05:30:00	QQQ	ETF	51.65	51.67	51.65	51.67	2000.0
2010-11-17 06:00:00	QQQ	ETF	51.69	51.69	51.57	51.57	970.0
2010-11-17 06:30:00	QQQ	ETF	51.58	51.58	51.58	51.58	1190.0
2010-11-17 07:00:00	QQQ	ETF	51.52	51.54	51.48	51.49	60520.0
2010-11-17 07:30:00	QQQ	ETF	51.46	51.66	51.46	51.61	57504.0
2010-11-17 08:00:00	QQQ	ETF	51.56	51.61	51.56	51.57	230616.0
2010-11-17 08:30:00	QQQ	ETF	51.57	51.68	51.5	51.54	474530.0
2010-11-17 09:00:00	QQQ	ETF	51.55	51.58	51.48	51.49	206999.0
2010-11-17 09:30:00	QQQ	ETF	51.49	51.64	51.38	51.59	9186492.0
2010-11-17 10:00:00	QQQ	ETF	51.59	51.8	51.59	51.8	5933450.0
2010-11-17 10:30:00	QQQ	ETF	51.8	51.85	51.73	51.7617	5730871.0
2010-11-17 11:00:00	QQQ	ETF	51.77	51.85	51.67	51.82	3578849.0
2010-11-17 11:30:00	QQQ	ETF	51.81	51.84	51.68	51.81	5272905.0
2010-11-17 12:00:00	QQQ	ETF	51.808	51.83	51.71	51.73	1553444.0
2010-11-17 12:30:00	QQQ	ETF	51.73	51.7881	51.71	51.75	1528339.0
2010-11-17 13:00:00	QQQ	ETF	51.74	51.8301	51.69	51.83	1492371.0

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

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