PREVIEW / etf_30min / 2012-03-30

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-30.parquet
  size:    278 KB
  rows:    9,459

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-30 04:00:00	SPY	ETF	140.66	140.66	140.51	140.51	4150.0
2012-03-30 04:30:00	SPY	ETF	140.7	140.78	140.7	140.78	6690.0
2012-03-30 05:00:00	SPY	ETF	140.72	140.76	140.72	140.76	2700.0
2012-03-30 05:30:00	SPY	ETF	140.93	141.01	140.93	141.01	6000.0
2012-03-30 06:00:00	SPY	ETF	140.98	140.98	140.88	140.88	94600.0
2012-03-30 06:30:00	SPY	ETF	140.91	140.96	140.83	140.9	70700.0
2012-03-30 07:00:00	SPY	ETF	140.87	140.98	140.87	140.96	178117.0
2012-03-30 07:30:00	SPY	ETF	140.96	141.03	140.9	141.0	121189.0
2012-03-30 08:00:00	SPY	ETF	140.98	141.05	140.81	140.86	798400.0
2012-03-30 08:30:00	SPY	ETF	140.86	140.91	140.74	140.84	661152.0
2012-03-30 09:00:00	SPY	ETF	140.86	140.96	140.82	140.92	689419.0
2012-03-30 09:30:00	SPY	ETF	140.92	140.97	140.58	140.5999	17624442.0
2012-03-30 10:00:00	SPY	ETF	140.6	140.72	140.27	140.4	11883413.0
2012-03-30 10:30:00	SPY	ETF	140.4	140.46	140.05	140.31	12017123.0
2012-03-30 11:00:00	SPY	ETF	140.31	140.8	140.29	140.77	10061786.0
2012-03-30 11:30:00	SPY	ETF	140.77	140.84	140.2661	140.765	8756127.0
2012-03-30 12:00:00	SPY	ETF	140.76	140.79	140.67	140.755	6002655.0
2012-03-30 12:30:00	SPY	ETF	140.76	140.92	140.72	140.76	4223552.0
2012-03-30 13:00:00	SPY	ETF	140.77	140.91	140.74	140.86	3395892.0
2012-03-30 13:30:00	SPY	ETF	140.865	140.93	140.84	140.89	3092769.0
2012-03-30 14:00:00	SPY	ETF	140.895	141.0	140.86	140.87	5080885.0
2012-03-30 14:30:00	SPY	ETF	140.86	141.05	140.82	140.84	5075472.0
2012-03-30 15:00:00	SPY	ETF	140.835	140.92	140.77	140.83	6222724.0
2012-03-30 15:30:00	SPY	ETF	140.83	140.95	140.63	140.72	23546612.0
2012-03-30 16:00:00	SPY	ETF	140.72	141.0	140.266	140.86	8321083.0
2012-03-30 16:30:00	SPY	ETF	140.86	140.93	140.84	140.87	3269888.0
2012-03-30 17:00:00	SPY	ETF	140.87	140.95	140.2661	140.91	1192126.0
2012-03-30 17:30:00	SPY	ETF	140.91	141.04	140.91	140.95	360254.0
2012-03-30 18:00:00	SPY	ETF	140.99	140.99	140.84	140.85	87913.0
2012-03-30 18:30:00	SPY	ETF	140.86	140.88	140.85	140.88	11800.0
2012-03-30 19:00:00	SPY	ETF	140.86	140.9	140.85	140.89	13700.0
2012-03-30 19:30:00	SPY	ETF	140.89	140.95	140.86	140.95	19659.0
2012-03-30 04:00:00	QQQ	ETF	67.81	67.94	67.81	67.94	1200.0
2012-03-30 04:30:00	QQQ	ETF	67.85	67.9	67.85	67.9	200.0
2012-03-30 05:00:00	QQQ	ETF	67.97	67.97	67.97	67.97	100.0
2012-03-30 05:30:00	QQQ	ETF	67.99	68.06	67.99	68.06	4980.0
2012-03-30 06:00:00	QQQ	ETF	68.0	68.0	68.0	68.0	11000.0
2012-03-30 06:30:00	QQQ	ETF	68.01	68.03	68.0	68.0	8400.0
2012-03-30 07:00:00	QQQ	ETF	68.02	68.04	68.02	68.04	11500.0
2012-03-30 07:30:00	QQQ	ETF	68.03	68.07	68.03	68.06	24685.0
2012-03-30 08:00:00	QQQ	ETF	68.05	68.08	67.97	68.0	53915.0
2012-03-30 08:30:00	QQQ	ETF	67.98	68.01	67.93	67.96	533014.0
2012-03-30 09:00:00	QQQ	ETF	67.94	68.02	67.93	67.99	237516.0
2012-03-30 09:30:00	QQQ	ETF	67.99	68.02	67.65	67.66	5284741.0
2012-03-30 10:00:00	QQQ	ETF	67.65	67.749	67.48	67.5	3672892.0
2012-03-30 10:30:00	QQQ	ETF	67.505	67.52	67.28	67.5	4239096.0
2012-03-30 11:00:00	QQQ	ETF	67.5	67.7489	67.49	67.71	3864835.0
2012-03-30 11:30:00	QQQ	ETF	67.71	67.75	67.63	67.71	4179394.0
2012-03-30 12:00:00	QQQ	ETF	67.705	67.71	67.58	67.66	3077788.0
2012-03-30 12:30:00	QQQ	ETF	67.66	67.74	67.62	67.655	788327.0

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

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