PREVIEW / etf_30min / 2011-01-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-07.parquet
  size:    279 KB
  rows:    9,104

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
2011-01-07 04:00:00	SPY	ETF	127.15	127.22	127.11	127.22	700.0
2011-01-07 04:30:00	SPY	ETF	127.2	127.2	127.2	127.2	100.0
2011-01-07 05:00:00	SPY	ETF	127.18	127.18	127.01	127.01	2160.0
2011-01-07 05:30:00	SPY	ETF	127.2	127.2	127.2	127.2	500.0
2011-01-07 06:00:00	SPY	ETF	127.19	127.19	127.15	127.17	2400.0
2011-01-07 06:30:00	SPY	ETF	127.27	127.44	127.27	127.44	9650.0
2011-01-07 07:00:00	SPY	ETF	127.45	127.45	127.35	127.43	43720.0
2011-01-07 07:30:00	SPY	ETF	127.41	127.41	127.3	127.35	174922.0
2011-01-07 08:00:00	SPY	ETF	127.38	127.65	127.35	127.59	836339.0
2011-01-07 08:30:00	SPY	ETF	127.6	127.9	126.67	127.4	10800090.0
2011-01-07 09:00:00	SPY	ETF	127.4	127.62	127.39	127.56	1929896.0
2011-01-07 09:30:00	SPY	ETF	127.56	127.77	127.16	127.25	15614399.0
2011-01-07 10:00:00	SPY	ETF	127.255	127.6	127.21	127.53	11360792.0
2011-01-07 10:30:00	SPY	ETF	127.54	127.65	127.06	127.19	13315229.0
2011-01-07 11:00:00	SPY	ETF	127.18	127.19	126.8	126.84	13160857.0
2011-01-07 11:30:00	SPY	ETF	126.835	126.94	126.57	126.87	10394576.0
2011-01-07 12:00:00	SPY	ETF	126.86	126.88	126.58	126.58	5078713.0
2011-01-07 12:30:00	SPY	ETF	126.59	126.62	126.15	126.5	12400119.0
2011-01-07 13:00:00	SPY	ETF	126.4962	126.74	126.43	126.625	7758736.0
2011-01-07 13:30:00	SPY	ETF	126.629	126.8	126.58	126.615	6845678.0
2011-01-07 14:00:00	SPY	ETF	126.62	126.86	126.58	126.81	4534274.0
2011-01-07 14:30:00	SPY	ETF	126.805	127.01	126.7	126.88	7279928.0
2011-01-07 15:00:00	SPY	ETF	126.88	127.13	126.8175	126.97	9612111.0
2011-01-07 15:30:00	SPY	ETF	126.98	127.23	126.93	127.12	16175197.0
2011-01-07 16:00:00	SPY	ETF	127.13	127.605	126.515	127.14	6876022.0
2011-01-07 16:30:00	SPY	ETF	127.12	127.25	127.061	127.17	445951.0
2011-01-07 17:00:00	SPY	ETF	127.17	127.25	127.15	127.2	30820.0
2011-01-07 17:30:00	SPY	ETF	127.2	127.25	127.2	127.2	13500.0
2011-01-07 18:00:00	SPY	ETF	127.21	127.21	127.13	127.13	26239.0
2011-01-07 18:30:00	SPY	ETF	127.19	127.25	127.17	127.22	23970.0
2011-01-07 19:00:00	SPY	ETF	127.22	127.24	127.21	127.24	12488.0
2011-01-07 19:30:00	SPY	ETF	127.23	127.26	127.22	127.24	11412.0
2011-01-07 04:30:00	QQQ	ETF	55.85	55.86	55.85	55.86	2600.0
2011-01-07 06:30:00	QQQ	ETF	55.85	55.91	55.85	55.91	270.0
2011-01-07 07:00:00	QQQ	ETF	55.92	55.93	55.92	55.93	1100.0
2011-01-07 07:30:00	QQQ	ETF	55.93	55.96	55.92	55.95	86794.0
2011-01-07 08:00:00	QQQ	ETF	55.94	56.05	55.94	56.03	675245.0
2011-01-07 08:30:00	QQQ	ETF	55.99	56.0	55.69	55.94	1323027.0
2011-01-07 09:00:00	QQQ	ETF	55.95	56.04	55.95	56.02	543040.0
2011-01-07 09:30:00	QQQ	ETF	56.02	56.05	55.73	55.83	13054019.0
2011-01-07 10:00:00	QQQ	ETF	55.825	55.9906	55.81	55.96	6590779.0
2011-01-07 10:30:00	QQQ	ETF	55.97	56.02	55.8	55.85	6378465.0
2011-01-07 11:00:00	QQQ	ETF	55.845	55.87	55.75	55.76	3804284.0
2011-01-07 11:30:00	QQQ	ETF	55.76	55.81	55.66	55.8	4393478.0
2011-01-07 12:00:00	QQQ	ETF	55.805	55.805	55.67	55.68	2291041.0
2011-01-07 12:30:00	QQQ	ETF	55.67	55.685	55.32	55.55	10930030.0
2011-01-07 13:00:00	QQQ	ETF	55.55	55.66	55.5	55.6	4044255.0
2011-01-07 13:30:00	QQQ	ETF	55.6099	55.74	55.6099	55.64	2157052.0
2011-01-07 14:00:00	QQQ	ETF	55.64	55.75	55.625	55.725	1196113.0
2011-01-07 14:30:00	QQQ	ETF	55.72	55.81	55.67	55.74	1763394.0

> showing 50 of 9,104 rows — these rows as CSV

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