PREVIEW / etf_30min / 2011-01-26

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-26.parquet
  size:    273 KB
  rows:    9,291

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-26 04:00:00	SPY	ETF	129.25	129.65	129.25	129.65	5900.0
2011-01-26 04:30:00	SPY	ETF	129.66	129.7	129.66	129.7	700.0
2011-01-26 05:00:00	SPY	ETF	129.66	129.68	129.65	129.68	3200.0
2011-01-26 05:30:00	SPY	ETF	129.66	129.7	129.66	129.7	900.0
2011-01-26 06:00:00	SPY	ETF	129.72	129.72	129.69	129.69	700.0
2011-01-26 06:30:00	SPY	ETF	129.68	129.8	129.67	129.8	120322.0
2011-01-26 07:00:00	SPY	ETF	129.8	129.81	129.61	129.62	95700.0
2011-01-26 07:30:00	SPY	ETF	129.62	129.7	129.59	129.6	161735.0
2011-01-26 08:00:00	SPY	ETF	129.6	129.68	128.1863	129.67	376199.0
2011-01-26 08:30:00	SPY	ETF	129.67	129.68	129.44	129.48	406349.0
2011-01-26 09:00:00	SPY	ETF	129.47	129.51	129.4	129.49	491060.0
2011-01-26 09:30:00	SPY	ETF	129.49	129.54	129.23	129.39	13321113.0
2011-01-26 10:00:00	SPY	ETF	129.39	129.94	129.34	129.9	16100380.0
2011-01-26 10:30:00	SPY	ETF	129.9	129.99	129.68	129.75	10373130.0
2011-01-26 11:00:00	SPY	ETF	129.755	129.93	129.51	129.52	7026023.0
2011-01-26 11:30:00	SPY	ETF	129.52	129.69	129.44	129.595	5515905.0
2011-01-26 12:00:00	SPY	ETF	129.6	129.72	129.52	129.671	4011109.0
2011-01-26 12:30:00	SPY	ETF	129.68	129.82	129.67	129.775	8018948.0
2011-01-26 13:00:00	SPY	ETF	129.77	129.82	129.68	129.8	3792263.0
2011-01-26 13:30:00	SPY	ETF	129.8	129.94	129.71	129.81	5379564.0
2011-01-26 14:00:00	SPY	ETF	129.81	130.0	129.52	129.65	11453238.0
2011-01-26 14:30:00	SPY	ETF	129.66	130.05	129.59	129.92	13043653.0
2011-01-26 15:00:00	SPY	ETF	129.925	130.05	129.77	129.925	10167472.0
2011-01-26 15:30:00	SPY	ETF	129.92	129.97	129.67	129.67	16683937.0
2011-01-26 16:00:00	SPY	ETF	129.67	129.825	129.275	129.77	8801399.0
2011-01-26 16:30:00	SPY	ETF	129.76	129.86	129.68	129.72	5473540.0
2011-01-26 17:00:00	SPY	ETF	129.71	129.72	129.65	129.67	199704.0
2011-01-26 17:30:00	SPY	ETF	129.69	129.71	129.68	129.69	10700.0
2011-01-26 18:00:00	SPY	ETF	129.67	129.69	129.6	129.66	110504.0
2011-01-26 18:30:00	SPY	ETF	129.65	129.69	129.63	129.66	18700.0
2011-01-26 19:00:00	SPY	ETF	129.67	129.77	129.67	129.73	22300.0
2011-01-26 19:30:00	SPY	ETF	129.74	129.79	129.73	129.77	18018.0
2011-01-26 04:00:00	QQQ	ETF	56.64	56.7	56.64	56.7	1174.0
2011-01-26 04:30:00	QQQ	ETF	56.72	56.72	56.72	56.72	700.0
2011-01-26 06:30:00	QQQ	ETF	56.69	56.78	56.69	56.77	2500.0
2011-01-26 07:00:00	QQQ	ETF	56.77	56.78	56.72	56.72	17278.0
2011-01-26 07:30:00	QQQ	ETF	56.73	56.75	56.69	56.73	101922.0
2011-01-26 08:00:00	QQQ	ETF	56.7	56.71	56.51	56.7	65795.0
2011-01-26 08:30:00	QQQ	ETF	56.7	56.7	56.64	56.68	97915.0
2011-01-26 09:00:00	QQQ	ETF	56.67	56.67	56.61	56.64	252805.0
2011-01-26 09:30:00	QQQ	ETF	56.63	56.66	56.45	56.57	7605271.0
2011-01-26 10:00:00	QQQ	ETF	56.56	56.96	56.54	56.95	7789596.0
2011-01-26 10:30:00	QQQ	ETF	56.94	56.98	56.81	56.845	3422205.0
2011-01-26 11:00:00	QQQ	ETF	56.84	56.9	56.74	56.745	2285943.0
2011-01-26 11:30:00	QQQ	ETF	56.74	56.81	56.68	56.74	2580442.0
2011-01-26 12:00:00	QQQ	ETF	56.7401	56.82	56.73	56.8	804736.0
2011-01-26 12:30:00	QQQ	ETF	56.81	56.88	56.81	56.86	2913365.0
2011-01-26 13:00:00	QQQ	ETF	56.855	56.875	56.79	56.83	2213305.0
2011-01-26 13:30:00	QQQ	ETF	56.83	56.95	56.82	56.9	2090382.0
2011-01-26 14:00:00	QQQ	ETF	56.89	56.95	56.75	56.82	3071590.0

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

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