PREVIEW / etf_30min / 2012-03-07

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-07.parquet
  size:    280 KB
  rows:    9,532

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
2012-03-07 04:00:00	SPY	ETF	135.09	135.19	135.02	135.19	5460.0
2012-03-07 04:30:00	SPY	ETF	135.23	135.28	135.19	135.19	1700.0
2012-03-07 05:00:00	SPY	ETF	135.17	135.37	135.17	135.37	2100.0
2012-03-07 05:30:00	SPY	ETF	135.34	135.35	135.29	135.35	27000.0
2012-03-07 06:00:00	SPY	ETF	135.24	135.29	135.24	135.26	6600.0
2012-03-07 06:30:00	SPY	ETF	135.26	135.32	135.25	135.31	48902.0
2012-03-07 07:00:00	SPY	ETF	135.26	135.34	135.21	135.27	196743.0
2012-03-07 07:30:00	SPY	ETF	135.26	135.3	135.13	135.25	116780.0
2012-03-07 08:00:00	SPY	ETF	135.25	135.3	135.0	135.28	475419.0
2012-03-07 08:30:00	SPY	ETF	135.27	135.39	135.22	135.36	993318.0
2012-03-07 09:00:00	SPY	ETF	135.37	135.41	135.05	135.06	1820145.0
2012-03-07 09:30:00	SPY	ETF	135.06	135.23	134.93	135.1585	16092056.0
2012-03-07 10:00:00	SPY	ETF	135.16	135.24	134.96	135.06	9743124.0
2012-03-07 10:30:00	SPY	ETF	135.07	135.19	135.01	135.142	8273974.0
2012-03-07 11:00:00	SPY	ETF	135.15	135.68	135.15	135.58	19171460.0
2012-03-07 11:30:00	SPY	ETF	135.58	135.66	135.54	135.64	6404113.0
2012-03-07 12:00:00	SPY	ETF	135.63	135.71	135.51	135.62	5689339.0
2012-03-07 12:30:00	SPY	ETF	135.61	135.75	135.57	135.69	4040268.0
2012-03-07 13:00:00	SPY	ETF	135.69	135.72	135.58	135.63	5645056.0
2012-03-07 13:30:00	SPY	ETF	135.63	135.66	135.47	135.581	6644877.0
2012-03-07 14:00:00	SPY	ETF	135.5801	135.78	135.5801	135.72	6771413.0
2012-03-07 14:30:00	SPY	ETF	135.73	135.76	135.53	135.73	7728260.0
2012-03-07 15:00:00	SPY	ETF	135.72	135.8393	135.55	135.7595	8108189.0
2012-03-07 15:30:00	SPY	ETF	135.77	135.91	135.67	135.72	18711253.0
2012-03-07 16:00:00	SPY	ETF	135.71	135.81	135.4813	135.74	5279057.0
2012-03-07 16:30:00	SPY	ETF	135.75	135.75	134.7574	135.67	4768155.0
2012-03-07 17:00:00	SPY	ETF	134.7588	135.72	134.7588	135.69	1111428.0
2012-03-07 17:30:00	SPY	ETF	135.68	135.69	135.59	135.65	41024.0
2012-03-07 18:00:00	SPY	ETF	135.65	135.73	135.65	135.73	34829.0
2012-03-07 18:30:00	SPY	ETF	135.69	135.7	135.65	135.67	7050.0
2012-03-07 19:00:00	SPY	ETF	135.68	135.68	135.6	135.63	15911.0
2012-03-07 19:30:00	SPY	ETF	135.61	135.7	135.57	135.67	52400.0
2012-03-07 04:30:00	QQQ	ETF	63.83	63.83	63.81	63.81	500.0
2012-03-07 05:00:00	QQQ	ETF	63.89	63.89	63.89	63.89	150.0
2012-03-07 06:00:00	QQQ	ETF	63.85	63.88	63.85	63.88	7300.0
2012-03-07 06:30:00	QQQ	ETF	63.87	63.89	63.87	63.89	1100.0
2012-03-07 07:00:00	QQQ	ETF	63.91	63.91	63.85	63.87	21920.0
2012-03-07 07:30:00	QQQ	ETF	63.88	63.93	63.85	63.88	56700.0
2012-03-07 08:00:00	QQQ	ETF	63.87	63.94	63.84	63.91	153630.0
2012-03-07 08:30:00	QQQ	ETF	63.9	63.95	63.89	63.93	158594.0
2012-03-07 09:00:00	QQQ	ETF	63.93	63.94	63.84	63.85	497572.0
2012-03-07 09:30:00	QQQ	ETF	63.85	63.96	63.77	63.92	6056585.0
2012-03-07 10:00:00	QQQ	ETF	63.915	63.95	63.81	63.901	2963203.0
2012-03-07 10:30:00	QQQ	ETF	63.9	63.93	63.79	63.89	2009776.0
2012-03-07 11:00:00	QQQ	ETF	63.89	64.09	63.882	64.079	3500230.0
2012-03-07 11:30:00	QQQ	ETF	64.07	64.1	64.03	64.0979	1343002.0
2012-03-07 12:00:00	QQQ	ETF	64.1	64.18	64.085	64.14	2725806.0
2012-03-07 12:30:00	QQQ	ETF	64.14	64.21	64.0905	64.1885	1425858.0
2012-03-07 13:00:00	QQQ	ETF	64.18	64.205	64.06	64.11	3053101.0
2012-03-07 13:30:00	QQQ	ETF	64.11	64.14	63.93	64.05	3255806.0

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

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