PREVIEW / etf_30min / 2012-01-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-13.parquet
  size:    285 KB
  rows:    9,518

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-13 04:00:00	SPY	ETF	129.7	129.7	129.7	129.7	200.0
2012-01-13 04:30:00	SPY	ETF	129.62	129.68	129.52	129.68	1200.0
2012-01-13 05:00:00	SPY	ETF	129.65	129.74	129.45	129.49	7470.0
2012-01-13 05:30:00	SPY	ETF	129.54	129.62	129.44	129.52	14300.0
2012-01-13 06:00:00	SPY	ETF	129.58	129.58	129.58	129.58	1069.0
2012-01-13 06:30:00	SPY	ETF	129.56	129.56	129.42	129.44	72300.0
2012-01-13 07:00:00	SPY	ETF	129.49	129.49	129.27	129.41	310585.0
2012-01-13 07:30:00	SPY	ETF	129.41	129.5	129.11	129.15	330387.0
2012-01-13 08:00:00	SPY	ETF	129.22	129.45	129.16	129.26	384166.0
2012-01-13 08:30:00	SPY	ETF	129.26	129.26	128.52	128.76	2456158.0
2012-01-13 09:00:00	SPY	ETF	128.75	128.8	128.43	128.62	3793764.0
2012-01-13 09:30:00	SPY	ETF	128.64	128.71	128.24	128.52	24794381.0
2012-01-13 10:00:00	SPY	ETF	128.51	128.57	127.72	128.1	28639459.0
2012-01-13 10:30:00	SPY	ETF	128.1	128.32	127.97	128.3	19805759.0
2012-01-13 11:00:00	SPY	ETF	128.3	128.57	128.26	128.525	13270189.0
2012-01-13 11:30:00	SPY	ETF	128.54	128.72	128.51	128.52	6693501.0
2012-01-13 12:00:00	SPY	ETF	128.53	128.53	128.26	128.3	7568671.0
2012-01-13 12:30:00	SPY	ETF	128.31	128.41	128.17	128.39	8832000.0
2012-01-13 13:00:00	SPY	ETF	128.4	128.4	128.04	128.18	6300608.0
2012-01-13 13:30:00	SPY	ETF	128.17	128.53	128.09	128.435	6031633.0
2012-01-13 14:00:00	SPY	ETF	128.4372	128.61	128.33	128.54	8019130.0
2012-01-13 14:30:00	SPY	ETF	128.55	128.63	128.47	128.61	6612246.0
2012-01-13 15:00:00	SPY	ETF	128.62	128.88	128.59	128.79	10749077.0
2012-01-13 15:30:00	SPY	ETF	128.79	128.96	128.77	128.95	15986699.0
2012-01-13 16:00:00	SPY	ETF	128.96	129.45	128.3947	129.3	7193239.0
2012-01-13 16:30:00	SPY	ETF	129.29	129.3	129.02	129.13	654563.0
2012-01-13 17:00:00	SPY	ETF	129.12	129.18	129.09	129.12	232829.0
2012-01-13 17:30:00	SPY	ETF	129.12	129.22	129.09	129.18	92073.0
2012-01-13 18:00:00	SPY	ETF	129.16	129.2	129.01	129.17	62158.0
2012-01-13 18:30:00	SPY	ETF	129.17	129.22	129.16	129.17	19701.0
2012-01-13 19:00:00	SPY	ETF	129.18	129.2	129.15	129.15	98210.0
2012-01-13 19:30:00	SPY	ETF	129.19	129.24	129.15	129.24	43024.0
2012-01-13 06:30:00	QQQ	ETF	58.46	58.46	58.41	58.41	6100.0
2012-01-13 07:00:00	QQQ	ETF	58.4	58.43	58.38	58.41	8100.0
2012-01-13 07:30:00	QQQ	ETF	58.45	58.45	58.33	58.33	6170.0
2012-01-13 08:00:00	QQQ	ETF	58.37	58.4	58.35	58.38	57491.0
2012-01-13 08:30:00	QQQ	ETF	58.38	58.38	58.2	58.2	365711.0
2012-01-13 09:00:00	QQQ	ETF	58.2	58.22	58.0	58.09	1279012.0
2012-01-13 09:30:00	QQQ	ETF	58.09	58.2	57.9	58.109	5279731.0
2012-01-13 10:00:00	QQQ	ETF	58.1	58.1015	57.68	57.84	6586146.0
2012-01-13 10:30:00	QQQ	ETF	57.83	57.92	57.77	57.916	2388366.0
2012-01-13 11:00:00	QQQ	ETF	57.91	58.05	57.88	58.02	2869471.0
2012-01-13 11:30:00	QQQ	ETF	58.019	58.115	58.019	58.04	1192142.0
2012-01-13 12:00:00	QQQ	ETF	58.03	58.04	57.94	57.95	1932568.0
2012-01-13 12:30:00	QQQ	ETF	57.9598	58.0	57.91	58.0	1178732.0
2012-01-13 13:00:00	QQQ	ETF	57.99	57.99	57.86	57.91	1269819.0
2012-01-13 13:30:00	QQQ	ETF	57.91	58.03	57.865	57.98	1195316.0
2012-01-13 14:00:00	QQQ	ETF	57.98	58.1	57.94	58.06	1583146.0
2012-01-13 14:30:00	QQQ	ETF	58.06	58.1	57.985	58.044	1270113.0
2012-01-13 15:00:00	QQQ	ETF	58.05	58.18	58.04	58.155	2121047.0

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

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