PREVIEW / etf_30min / 2014-01-09

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-09.parquet
  size:    343 KB
  rows:    11,521

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
2014-01-09 04:00:00	SPY	ETF	183.57	184.12	183.57	184.01	33770.0
2014-01-09 04:30:00	SPY	ETF	184.02	184.13	183.99	184.13	13898.0
2014-01-09 05:00:00	SPY	ETF	184.14	184.21	184.09	184.21	11108.0
2014-01-09 05:30:00	SPY	ETF	184.18	184.2	184.14	184.14	66089.0
2014-01-09 06:00:00	SPY	ETF	184.17	184.17	184.09	184.1	4376.0
2014-01-09 06:30:00	SPY	ETF	184.11	184.12	184.06	184.08	9277.0
2014-01-09 07:00:00	SPY	ETF	184.03	184.15	184.03	184.13	14108.0
2014-01-09 07:30:00	SPY	ETF	184.07	184.11	184.04	184.06	30313.0
2014-01-09 08:00:00	SPY	ETF	184.07	184.08	183.89	183.93	179978.0
2014-01-09 08:30:00	SPY	ETF	183.97	184.12	183.88	183.92	775700.0
2014-01-09 09:00:00	SPY	ETF	183.91	184.11	183.9	184.1	429230.0
2014-01-09 09:30:00	SPY	ETF	184.1	184.13	183.77	184.03	7414809.0
2014-01-09 10:00:00	SPY	ETF	184.03	184.1	183.5199	183.555	8567566.0
2014-01-09 10:30:00	SPY	ETF	183.57	183.66	182.93	183.12	10368229.0
2014-01-09 11:00:00	SPY	ETF	183.12	183.13	182.795	183.06	11822320.0
2014-01-09 11:30:00	SPY	ETF	183.06	183.22	182.97	183.18	4483135.0
2014-01-09 12:00:00	SPY	ETF	183.18	183.32	183.13	183.3	3044904.0
2014-01-09 12:30:00	SPY	ETF	183.295	183.59	183.291	183.59	4071594.0
2014-01-09 13:00:00	SPY	ETF	183.58	183.61	183.4	183.51	4158195.0
2014-01-09 13:30:00	SPY	ETF	183.51	183.57	183.23	183.27	3205054.0
2014-01-09 14:00:00	SPY	ETF	183.27	183.3	182.98	183.26	3727436.0
2014-01-09 14:30:00	SPY	ETF	183.25	183.55	183.11	183.42	4279593.0
2014-01-09 15:00:00	SPY	ETF	183.41	183.74	183.37	183.68	4894993.0
2014-01-09 15:30:00	SPY	ETF	183.68	183.77	183.48	183.63	9564541.0
2014-01-09 16:00:00	SPY	ETF	183.64	184.03	183.5478	183.65	7438000.0
2014-01-09 16:30:00	SPY	ETF	183.66	184.03	183.63	184.03	828171.0
2014-01-09 17:00:00	SPY	ETF	184.04	184.04	183.67	183.69	59281.0
2014-01-09 17:30:00	SPY	ETF	183.71	184.02	183.69	183.71	39782.0
2014-01-09 18:00:00	SPY	ETF	183.71	183.71	183.63	183.63	36289.0
2014-01-09 18:30:00	SPY	ETF	183.65	183.68	183.65	183.67	2000.0
2014-01-09 19:00:00	SPY	ETF	183.67	183.7	183.67	183.7	7600.0
2014-01-09 19:30:00	SPY	ETF	183.69	183.73	183.67	183.69	87700.0
2014-01-09 04:00:00	QQQ	ETF	87.5	87.66	87.5	87.64	7540.0
2014-01-09 04:30:00	QQQ	ETF	87.65	87.66	87.65	87.66	400.0
2014-01-09 05:00:00	QQQ	ETF	87.67	87.69	87.66	87.69	3100.0
2014-01-09 06:00:00	QQQ	ETF	87.69	87.69	87.68	87.68	200.0
2014-01-09 06:30:00	QQQ	ETF	87.67	87.67	87.62	87.62	5100.0
2014-01-09 07:00:00	QQQ	ETF	87.63	87.67	87.61	87.67	5700.0
2014-01-09 07:30:00	QQQ	ETF	87.63	87.65	87.62	87.62	14650.0
2014-01-09 08:00:00	QQQ	ETF	87.63	87.63	87.52	87.55	45423.0
2014-01-09 08:30:00	QQQ	ETF	87.55	87.64	87.53	87.55	184172.0
2014-01-09 09:00:00	QQQ	ETF	87.55	87.66	87.55	87.63	77504.0
2014-01-09 09:30:00	QQQ	ETF	87.62	87.64	87.439	87.56	2635529.0
2014-01-09 10:00:00	QQQ	ETF	87.56	87.61	87.15	87.2	2872647.0
2014-01-09 10:30:00	QQQ	ETF	87.2	87.2599	86.87	86.96	2581355.0
2014-01-09 11:00:00	QQQ	ETF	86.95	86.95	86.76	86.87	2241226.0
2014-01-09 11:30:00	QQQ	ETF	86.86	86.98	86.82	86.93	1369303.0
2014-01-09 12:00:00	QQQ	ETF	86.93	87.0	86.88	86.99	748711.0
2014-01-09 12:30:00	QQQ	ETF	86.99	87.15	86.99	87.12	1264230.0
2014-01-09 13:00:00	QQQ	ETF	87.12	87.13	87.03	87.08	699041.0

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

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