PREVIEW / etf_30min / 2011-12-21

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-21.parquet
  size:    288 KB
  rows:    9,662

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-12-21 04:00:00	SPY	ETF	124.49	124.65	124.49	124.53	43985.0
2011-12-21 04:30:00	SPY	ETF	124.6	124.7	124.6	124.64	3200.0
2011-12-21 05:00:00	SPY	ETF	124.64	125.2	124.63	125.17	70905.0
2011-12-21 05:30:00	SPY	ETF	125.15	125.2	124.57	124.57	11329.0
2011-12-21 06:00:00	SPY	ETF	124.55	124.85	124.41	124.85	30830.0
2011-12-21 06:30:00	SPY	ETF	124.75	124.75	124.16	124.34	74050.0
2011-12-21 07:00:00	SPY	ETF	124.32	124.44	124.24	124.25	132697.0
2011-12-21 07:30:00	SPY	ETF	124.23	124.27	123.71	123.9	1561873.0
2011-12-21 08:00:00	SPY	ETF	123.87	124.8	123.32	123.59	5099477.0
2011-12-21 08:30:00	SPY	ETF	123.58	123.9	123.52	123.89	1715607.0
2011-12-21 09:00:00	SPY	ETF	123.89	124.05	123.84	123.93	1537327.0
2011-12-21 09:30:00	SPY	ETF	123.93	124.05	123.13	123.26	21746824.0
2011-12-21 10:00:00	SPY	ETF	123.26	123.76	123.06	123.47	20160355.0
2011-12-21 10:30:00	SPY	ETF	123.46	123.76	123.2	123.29	12779987.0
2011-12-21 11:00:00	SPY	ETF	123.3	123.33	122.97	123.12	11035335.0
2011-12-21 11:30:00	SPY	ETF	123.14	123.29	123.04	123.2	7058860.0
2011-12-21 12:00:00	SPY	ETF	123.2	123.29	122.75	122.84	10600760.0
2011-12-21 12:30:00	SPY	ETF	122.85	123.38	122.84	123.33	11517782.0
2011-12-21 13:00:00	SPY	ETF	123.33	123.55	123.28	123.34	6546433.0
2011-12-21 13:30:00	SPY	ETF	123.34	123.62	123.15	123.58	7204249.0
2011-12-21 14:00:00	SPY	ETF	123.59	123.9612	123.49	123.56	9939525.0
2011-12-21 14:30:00	SPY	ETF	123.56	123.86	123.41	123.72	11722402.0
2011-12-21 15:00:00	SPY	ETF	123.73	124.14	123.62	124.028	14367365.0
2011-12-21 15:30:00	SPY	ETF	124.03	124.36	123.84	124.2	26552134.0
2011-12-21 16:00:00	SPY	ETF	124.205	124.39	123.2083	124.1	8848371.0
2011-12-21 16:30:00	SPY	ETF	124.07	124.13	123.84	123.97	409622.0
2011-12-21 17:00:00	SPY	ETF	123.98	124.08	123.94	124.08	1076122.0
2011-12-21 17:30:00	SPY	ETF	124.07	124.15	123.9612	124.11	1032636.0
2011-12-21 18:00:00	SPY	ETF	124.12	124.17	123.96	124.03	249200.0
2011-12-21 18:30:00	SPY	ETF	124.07	124.09	124.02	124.07	17030.0
2011-12-21 19:00:00	SPY	ETF	124.06	124.11	124.03	124.07	23660.0
2011-12-21 19:30:00	SPY	ETF	124.08	124.13	124.01	124.11	55840.0
2011-12-21 04:00:00	QQQ	ETF	56.02	56.18	56.02	56.18	600.0
2011-12-21 04:30:00	QQQ	ETF	56.0	56.0	56.0	56.0	3985.0
2011-12-21 05:00:00	QQQ	ETF	56.15	56.15	56.15	56.15	998.0
2011-12-21 05:30:00	QQQ	ETF	55.9	55.9	55.9	55.9	4000.0
2011-12-21 06:00:00	QQQ	ETF	55.97	56.07	55.95	56.07	2400.0
2011-12-21 06:30:00	QQQ	ETF	56.04	56.04	55.76	55.78	23800.0
2011-12-21 07:00:00	QQQ	ETF	55.84	55.87	55.77	55.77	5804.0
2011-12-21 07:30:00	QQQ	ETF	55.75	55.78	55.6	55.68	577170.0
2011-12-21 08:00:00	QQQ	ETF	55.68	56.15	55.45	55.52	3353519.0
2011-12-21 08:30:00	QQQ	ETF	55.51	55.64	55.5	55.64	973588.0
2011-12-21 09:00:00	QQQ	ETF	55.64	55.71	55.53	55.63	1661510.0
2011-12-21 09:30:00	QQQ	ETF	55.64	55.65	54.98	55.065	9856412.0
2011-12-21 10:00:00	QQQ	ETF	55.06	55.18	54.92	55.04	6607021.0
2011-12-21 10:30:00	QQQ	ETF	55.03	55.15	54.83	54.9	5082823.0
2011-12-21 11:00:00	QQQ	ETF	54.9	54.91	54.7	54.775	3064691.0
2011-12-21 11:30:00	QQQ	ETF	54.77	54.83	54.68	54.75	2560365.0
2011-12-21 12:00:00	QQQ	ETF	54.745	54.8	54.4875	54.52	4936664.0
2011-12-21 12:30:00	QQQ	ETF	54.51	54.71	54.5	54.6801	3174789.0

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

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