PREVIEW / etf_30min / 2013-12-30

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-30.parquet
  size:    325 KB
  rows:    11,415

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-30 04:00:00	SPY	ETF	183.83	183.83	183.83	183.83	1700.0
2013-12-30 04:30:00	SPY	ETF	183.81	183.81	183.8	183.8	250.0
2013-12-30 05:00:00	SPY	ETF	183.83	183.85	183.83	183.83	5537.0
2013-12-30 05:30:00	SPY	ETF	183.85	184.0	183.84	184.0	6349.0
2013-12-30 06:00:00	SPY	ETF	183.98	184.01	183.95	183.95	23003.0
2013-12-30 06:30:00	SPY	ETF	183.97	184.08	183.97	183.98	6116.0
2013-12-30 07:00:00	SPY	ETF	183.96	183.98	183.89	183.94	14110.0
2013-12-30 07:30:00	SPY	ETF	183.97	184.0	183.93	183.95	75716.0
2013-12-30 08:00:00	SPY	ETF	183.95	184.01	183.85	183.88	107150.0
2013-12-30 08:30:00	SPY	ETF	183.89	183.93	183.84	183.85	110629.0
2013-12-30 09:00:00	SPY	ETF	183.85	183.88	183.78	183.87	261800.0
2013-12-30 09:30:00	SPY	ETF	183.87	184.02	183.67	183.685	6062641.0
2013-12-30 10:00:00	SPY	ETF	183.685	183.8	183.59	183.61	3363161.0
2013-12-30 10:30:00	SPY	ETF	183.61	183.75	183.58	183.69	3644461.0
2013-12-30 11:00:00	SPY	ETF	183.68	183.875	183.68	183.785	2767202.0
2013-12-30 11:30:00	SPY	ETF	183.79	183.87	183.64	183.72	4634082.0
2013-12-30 12:00:00	SPY	ETF	183.72	183.75	183.61	183.645	2317247.0
2013-12-30 12:30:00	SPY	ETF	183.6499	183.6799	183.58	183.63	2626526.0
2013-12-30 13:00:00	SPY	ETF	183.62	183.72	183.61	183.66	2085485.0
2013-12-30 13:30:00	SPY	ETF	183.65	183.72	183.58	183.68	3418426.0
2013-12-30 14:00:00	SPY	ETF	183.6799	183.76	183.67	183.76	2696102.0
2013-12-30 14:30:00	SPY	ETF	183.76	183.87	183.74	183.82	2686586.0
2013-12-30 15:00:00	SPY	ETF	183.83	183.84	183.71	183.72	2756885.0
2013-12-30 15:30:00	SPY	ETF	183.7216	183.82	183.65	183.81	8537059.0
2013-12-30 16:00:00	SPY	ETF	183.8	183.85	183.6	183.76	4826678.0
2013-12-30 16:30:00	SPY	ETF	183.75	183.81	183.74	183.77	2901990.0
2013-12-30 17:00:00	SPY	ETF	183.79	183.81	183.75	183.75	62400.0
2013-12-30 17:30:00	SPY	ETF	183.75	183.75	183.75	183.75	100.0
2013-12-30 18:00:00	SPY	ETF	183.78	183.78	183.73	183.73	10905.0
2013-12-30 18:30:00	SPY	ETF	183.74	183.75	183.74	183.75	2570.0
2013-12-30 19:00:00	SPY	ETF	183.74	183.77	183.74	183.77	17384.0
2013-12-30 19:30:00	SPY	ETF	183.76	183.76	183.74	183.75	19230.0
2013-12-30 06:00:00	QQQ	ETF	87.53	87.53	87.53	87.53	200.0
2013-12-30 06:30:00	QQQ	ETF	87.51	87.51	87.51	87.51	100.0
2013-12-30 07:00:00	QQQ	ETF	87.5	87.5	87.5	87.5	200.0
2013-12-30 07:30:00	QQQ	ETF	87.46	87.49	87.46	87.47	2775.0
2013-12-30 08:00:00	QQQ	ETF	87.49	87.49	87.43	87.43	14980.0
2013-12-30 08:30:00	QQQ	ETF	87.41	87.44	87.41	87.41	5285.0
2013-12-30 09:00:00	QQQ	ETF	87.37	87.38	87.34	87.38	88248.0
2013-12-30 09:30:00	QQQ	ETF	87.39	87.44	87.14	87.25	2407084.0
2013-12-30 10:00:00	QQQ	ETF	87.245	87.38	87.19	87.205	1456883.0
2013-12-30 10:30:00	QQQ	ETF	87.21	87.33	87.175	87.285	1553028.0
2013-12-30 11:00:00	QQQ	ETF	87.28	87.46	87.28	87.38	767716.0
2013-12-30 11:30:00	QQQ	ETF	87.39	87.43	87.3149	87.389	1163173.0
2013-12-30 12:00:00	QQQ	ETF	87.39	87.39	87.32	87.36	1073062.0
2013-12-30 12:30:00	QQQ	ETF	87.359	87.38	87.31	87.3201	552851.0
2013-12-30 13:00:00	QQQ	ETF	87.325	87.38	87.32	87.3699	618519.0
2013-12-30 13:30:00	QQQ	ETF	87.3699	87.41	87.34	87.355	953200.0
2013-12-30 14:00:00	QQQ	ETF	87.35	87.44	87.34	87.44	815355.0
2013-12-30 14:30:00	QQQ	ETF	87.43	87.51	87.43	87.4601	410867.0

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

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