PREVIEW / etf_30min / 2011-01-06

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-06.parquet
  size:    275 KB
  rows:    9,166

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-06 04:00:00	SPY	ETF	127.57	127.65	127.57	127.61	1400.0
2011-01-06 04:30:00	SPY	ETF	127.64	127.69	127.64	127.69	200.0
2011-01-06 05:00:00	SPY	ETF	127.8	127.8	127.8	127.8	300.0
2011-01-06 05:30:00	SPY	ETF	127.85	127.88	127.85	127.88	400.0
2011-01-06 06:00:00	SPY	ETF	127.91	127.95	127.9	127.9	2100.0
2011-01-06 06:30:00	SPY	ETF	127.96	128.0	127.91	127.91	69900.0
2011-01-06 07:00:00	SPY	ETF	127.94	128.02	127.93	128.0	75750.0
2011-01-06 07:30:00	SPY	ETF	128.0	128.07	127.89	127.92	260943.0
2011-01-06 08:00:00	SPY	ETF	127.89	128.0	127.88	127.9	824166.0
2011-01-06 08:30:00	SPY	ETF	127.9	127.92	127.7	127.72	2012896.0
2011-01-06 09:00:00	SPY	ETF	127.72	127.76	127.63	127.69	1331694.0
2011-01-06 09:30:00	SPY	ETF	127.69	127.74	127.48	127.49	12215729.0
2011-01-06 10:00:00	SPY	ETF	127.5	127.73	127.45	127.68	8210536.0
2011-01-06 10:30:00	SPY	ETF	127.69	127.83	127.4245	127.5	10604017.0
2011-01-06 11:00:00	SPY	ETF	127.5	127.52	127.01	127.3	12400578.0
2011-01-06 11:30:00	SPY	ETF	127.29	127.37	127.13	127.25	6844538.0
2011-01-06 12:00:00	SPY	ETF	127.25	127.28	127.1	127.21	4947780.0
2011-01-06 12:30:00	SPY	ETF	127.2	127.41	127.12	127.34	4472155.0
2011-01-06 13:00:00	SPY	ETF	127.34	127.345	127.125	127.19	4337413.0
2011-01-06 13:30:00	SPY	ETF	127.1955	127.51	127.18	127.51	6096701.0
2011-01-06 14:00:00	SPY	ETF	127.51	127.59	127.39	127.44	4785410.0
2011-01-06 14:30:00	SPY	ETF	127.44	127.44	127.11	127.23	7072930.0
2011-01-06 15:00:00	SPY	ETF	127.22	127.41	127.05	127.21	9020363.0
2011-01-06 15:30:00	SPY	ETF	127.21	127.46	127.16	127.39	13200394.0
2011-01-06 16:00:00	SPY	ETF	127.36	127.715	127.045	127.39	6065653.0
2011-01-06 16:30:00	SPY	ETF	127.38	127.38	127.32	127.36	5827307.0
2011-01-06 17:00:00	SPY	ETF	127.34	127.35	127.25	127.25	142837.0
2011-01-06 17:30:00	SPY	ETF	127.26	127.32	127.25	127.29	21000.0
2011-01-06 18:00:00	SPY	ETF	127.32	127.39	127.21	127.24	54687.0
2011-01-06 18:30:00	SPY	ETF	127.23	127.29	127.18	127.29	20880.0
2011-01-06 19:00:00	SPY	ETF	127.3	127.37	127.28	127.33	18311.0
2011-01-06 19:30:00	SPY	ETF	127.32	127.35	127.27	127.29	26251.0
2011-01-06 04:30:00	QQQ	ETF	55.82	55.85	55.82	55.85	380.0
2011-01-06 05:00:00	QQQ	ETF	55.87	55.88	55.87	55.88	300.0
2011-01-06 06:00:00	QQQ	ETF	55.89	55.89	55.89	55.89	100.0
2011-01-06 06:30:00	QQQ	ETF	55.94	55.95	55.94	55.95	2900.0
2011-01-06 07:00:00	QQQ	ETF	55.95	55.97	55.92	55.94	29150.0
2011-01-06 07:30:00	QQQ	ETF	55.97	55.98	55.9	55.9	42149.0
2011-01-06 08:00:00	QQQ	ETF	55.9	55.94	55.88	55.9	202904.0
2011-01-06 08:30:00	QQQ	ETF	55.9	55.91	55.8	55.81	138016.0
2011-01-06 09:00:00	QQQ	ETF	55.81	55.86	55.78	55.79	148201.0
2011-01-06 09:30:00	QQQ	ETF	55.79	55.85	55.69	55.75	5841747.0
2011-01-06 10:00:00	QQQ	ETF	55.755	55.91	55.75	55.91	3776034.0
2011-01-06 10:30:00	QQQ	ETF	55.91	55.94	55.78	55.805	4196469.0
2011-01-06 11:00:00	QQQ	ETF	55.8	55.85	55.68	55.83	4510601.0
2011-01-06 11:30:00	QQQ	ETF	55.82	55.86	55.75	55.819	2396954.0
2011-01-06 12:00:00	QQQ	ETF	55.811	55.83	55.75	55.8	2016307.0
2011-01-06 12:30:00	QQQ	ETF	55.79	55.87	55.75	55.831	1682295.0
2011-01-06 13:00:00	QQQ	ETF	55.83	55.84	55.77	55.78	2080469.0
2011-01-06 13:30:00	QQQ	ETF	55.79	55.92	55.78	55.92	2470413.0

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

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