PREVIEW / etf_30min / 2013-12-27

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-27.parquet
  size:    316 KB
  rows:    11,121

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
2013-12-27 04:00:00	SPY	ETF	183.76	183.76	183.76	183.76	1500.0
2013-12-27 04:30:00	SPY	ETF	183.74	183.74	183.72	183.72	6600.0
2013-12-27 05:00:00	SPY	ETF	183.7	183.7	183.64	183.64	1150.0
2013-12-27 05:30:00	SPY	ETF	183.63	183.63	183.53	183.53	12850.0
2013-12-27 06:00:00	SPY	ETF	183.66	183.66	183.66	183.66	150.0
2013-12-27 06:30:00	SPY	ETF	183.74	183.78	183.72	183.73	18450.0
2013-12-27 07:00:00	SPY	ETF	183.73	183.8	183.7	183.73	25895.0
2013-12-27 07:30:00	SPY	ETF	183.78	183.97	183.78	183.97	42179.0
2013-12-27 08:00:00	SPY	ETF	183.64	183.97	183.59	183.95	557126.0
2013-12-27 08:30:00	SPY	ETF	183.93	183.95	183.85	183.94	83247.0
2013-12-27 09:00:00	SPY	ETF	183.94	184.13	183.93	184.1	528177.0
2013-12-27 09:30:00	SPY	ETF	184.1	184.18	183.99	184.03	9483510.0
2013-12-27 10:00:00	SPY	ETF	184.03	184.13	184.0	184.001	3698926.0
2013-12-27 10:30:00	SPY	ETF	184.0	184.02	183.66	183.6697	7943610.0
2013-12-27 11:00:00	SPY	ETF	183.67	183.878	183.66	183.86	3678925.0
2013-12-27 11:30:00	SPY	ETF	183.87	183.98	183.79	183.888	3290248.0
2013-12-27 12:00:00	SPY	ETF	183.89	183.92	183.8	183.8899	1895664.0
2013-12-27 12:30:00	SPY	ETF	183.88	183.89	183.71	183.74	1870099.0
2013-12-27 13:00:00	SPY	ETF	183.7351	183.81	183.71	183.78	2932773.0
2013-12-27 13:30:00	SPY	ETF	183.775	183.82	183.69	183.79	1189585.0
2013-12-27 14:00:00	SPY	ETF	183.785	183.94	183.76	183.93	2928344.0
2013-12-27 14:30:00	SPY	ETF	183.92	183.93	183.76	183.77	2985058.0
2013-12-27 15:00:00	SPY	ETF	183.76	183.84	183.76	183.82	2379661.0
2013-12-27 15:30:00	SPY	ETF	183.82	183.91	183.77	183.83	9798484.0
2013-12-27 16:00:00	SPY	ETF	183.83	184.07	183.81	183.92	2865521.0
2013-12-27 16:30:00	SPY	ETF	183.9	183.92	183.828	183.8851	2551816.0
2013-12-27 17:00:00	SPY	ETF	183.89	183.9	183.79	183.79	135146.0
2013-12-27 17:30:00	SPY	ETF	183.8	183.8	183.679	183.7	70680.0
2013-12-27 18:00:00	SPY	ETF	183.72	183.77	183.72	183.75	13550.0
2013-12-27 18:30:00	SPY	ETF	183.75	183.8	183.75	183.79	2500.0
2013-12-27 19:00:00	SPY	ETF	183.8	183.8	183.79	183.79	800.0
2013-12-27 19:30:00	SPY	ETF	183.82	183.85	183.77	183.85	2535.0
2013-12-27 05:30:00	QQQ	ETF	87.7	87.7	87.68	87.7	1456.0
2013-12-27 06:00:00	QQQ	ETF	87.75	87.75	87.75	87.75	344.0
2013-12-27 06:30:00	QQQ	ETF	87.76	87.79	87.76	87.79	2352.0
2013-12-27 07:00:00	QQQ	ETF	87.77	87.77	87.77	87.77	5000.0
2013-12-27 07:30:00	QQQ	ETF	87.8	87.85	87.8	87.85	2420.0
2013-12-27 08:00:00	QQQ	ETF	87.85	87.85	87.81	87.82	18770.0
2013-12-27 08:30:00	QQQ	ETF	87.78	87.83	87.78	87.8	14800.0
2013-12-27 09:00:00	QQQ	ETF	87.819	87.85	87.79	87.84	123284.0
2013-12-27 09:30:00	QQQ	ETF	87.83	87.9	87.71	87.72	2344775.0
2013-12-27 10:00:00	QQQ	ETF	87.72	87.85	87.7	87.76	929896.0
2013-12-27 10:30:00	QQQ	ETF	87.76	87.76	87.51	87.5105	1508380.0
2013-12-27 11:00:00	QQQ	ETF	87.51	87.6699	87.51	87.665	1018541.0
2013-12-27 11:30:00	QQQ	ETF	87.67	87.71	87.58	87.64	567501.0
2013-12-27 12:00:00	QQQ	ETF	87.64	87.66	87.595	87.6201	399710.0
2013-12-27 12:30:00	QQQ	ETF	87.625	87.63	87.54	87.55	834719.0
2013-12-27 13:00:00	QQQ	ETF	87.56	87.58	87.52	87.54	667479.0
2013-12-27 13:30:00	QQQ	ETF	87.54	87.559	87.49	87.53	570290.0
2013-12-27 14:00:00	QQQ	ETF	87.54	87.595	87.52	87.57	424301.0

> showing 50 of 11,121 rows — these rows as CSV

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