PREVIEW / etf_30min / 2012-01-26

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-26.parquet
  size:    293 KB
  rows:    9,779

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-01-26 04:00:00	SPY	ETF	132.4	132.4	132.2	132.35	8062.0
2012-01-26 04:30:00	SPY	ETF	132.33	132.74	132.33	132.74	1800.0
2012-01-26 05:00:00	SPY	ETF	132.71	132.89	132.71	132.83	41550.0
2012-01-26 05:30:00	SPY	ETF	132.8	132.89	132.72	132.72	145750.0
2012-01-26 06:00:00	SPY	ETF	132.72	132.82	132.72	132.74	35000.0
2012-01-26 06:30:00	SPY	ETF	132.77	132.86	132.64	132.85	63050.0
2012-01-26 07:00:00	SPY	ETF	132.8	132.88	132.77	132.8	114222.0
2012-01-26 07:30:00	SPY	ETF	132.81	133.02	132.81	132.85	253797.0
2012-01-26 08:00:00	SPY	ETF	132.9	133.04	132.81	132.91	404745.0
2012-01-26 08:30:00	SPY	ETF	132.92	133.18	132.85	133.17	1815887.0
2012-01-26 09:00:00	SPY	ETF	133.17	133.17	132.29	133.16	1053541.0
2012-01-26 09:30:00	SPY	ETF	133.15	133.4	132.89	133.32	17337779.0
2012-01-26 10:00:00	SPY	ETF	133.32	133.325	132.66	132.69	15685736.0
2012-01-26 10:30:00	SPY	ETF	132.68	132.76	132.25	132.265	15678401.0
2012-01-26 11:00:00	SPY	ETF	132.27	132.52	132.23	132.49	11234988.0
2012-01-26 11:30:00	SPY	ETF	132.49	132.56	132.31	132.31	8629871.0
2012-01-26 12:00:00	SPY	ETF	132.32	132.38	132.06	132.195	10069588.0
2012-01-26 12:30:00	SPY	ETF	132.19	132.41	132.17	132.36	5334543.0
2012-01-26 13:00:00	SPY	ETF	132.36	132.45	132.27	132.28	4704134.0
2012-01-26 13:30:00	SPY	ETF	132.2702	132.28	131.88	132.03	8257955.0
2012-01-26 14:00:00	SPY	ETF	132.03	132.06	131.65	131.81	13125033.0
2012-01-26 14:30:00	SPY	ETF	131.82	131.96	131.67	131.74	7163907.0
2012-01-26 15:00:00	SPY	ETF	131.74	131.95	131.36	131.3915	16873089.0
2012-01-26 15:30:00	SPY	ETF	131.4	132.6242	131.385	131.88	23469994.0
2012-01-26 16:00:00	SPY	ETF	131.88	132.6242	131.75	131.94	11942570.0
2012-01-26 16:30:00	SPY	ETF	131.94	132.6242	131.86	132.03	1052879.0
2012-01-26 17:00:00	SPY	ETF	132.03	132.6242	132.02	132.05	7311654.0
2012-01-26 17:30:00	SPY	ETF	132.05	132.06	132.02	132.02	5782.0
2012-01-26 18:00:00	SPY	ETF	132.03	132.11	132.02	132.06	35996.0
2012-01-26 18:30:00	SPY	ETF	132.07	132.09	131.91	131.91	72130.0
2012-01-26 19:00:00	SPY	ETF	131.91	131.92	131.76	131.77	108022.0
2012-01-26 19:30:00	SPY	ETF	131.77	131.82	131.71	131.77	121974.0
2012-01-26 04:30:00	QQQ	ETF	60.3	60.3	60.3	60.3	100.0
2012-01-26 05:00:00	QQQ	ETF	60.55	60.55	60.51	60.52	1400.0
2012-01-26 05:30:00	QQQ	ETF	60.56	60.57	60.49	60.49	2150.0
2012-01-26 06:00:00	QQQ	ETF	60.52	60.52	60.49	60.49	300.0
2012-01-26 06:30:00	QQQ	ETF	60.47	60.47	60.44	60.44	3500.0
2012-01-26 07:00:00	QQQ	ETF	60.52	60.53	60.49	60.49	12400.0
2012-01-26 07:30:00	QQQ	ETF	60.54	60.56	60.52	60.54	18534.0
2012-01-26 08:00:00	QQQ	ETF	60.53	60.57	60.52	60.54	159360.0
2012-01-26 08:30:00	QQQ	ETF	60.6	60.69	60.5	60.68	500055.0
2012-01-26 09:00:00	QQQ	ETF	60.69	60.69	60.62	60.67	156731.0
2012-01-26 09:30:00	QQQ	ETF	60.67	60.8	60.5	60.76	3675010.0
2012-01-26 10:00:00	QQQ	ETF	60.76	60.788	60.54	60.55	3189294.0
2012-01-26 10:30:00	QQQ	ETF	60.55	60.5799	60.28	60.28	4187446.0
2012-01-26 11:00:00	QQQ	ETF	60.29	60.44	60.2607	60.4	2466968.0
2012-01-26 11:30:00	QQQ	ETF	60.4025	60.47	60.31	60.329	2154314.0
2012-01-26 12:00:00	QQQ	ETF	60.3299	60.4	60.22	60.27	2076422.0
2012-01-26 12:30:00	QQQ	ETF	60.27	60.37	60.25	60.35	1042275.0
2012-01-26 13:00:00	QQQ	ETF	60.35	60.39	60.3	60.309	1312669.0

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

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