PREVIEW / etf_30min / 2012-01-04

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-04.parquet
  size:    275 KB
  rows:    9,432

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-04 04:00:00	SPY	ETF	127.5	127.6	127.5	127.6	420.0
2012-01-04 05:00:00	SPY	ETF	127.84	127.84	127.84	127.84	100.0
2012-01-04 05:30:00	SPY	ETF	127.66	127.66	127.66	127.66	100.0
2012-01-04 06:00:00	SPY	ETF	127.5	127.5	127.35	127.41	4100.0
2012-01-04 06:30:00	SPY	ETF	127.3	127.43	127.29	127.43	81600.0
2012-01-04 07:00:00	SPY	ETF	127.25	127.53	127.25	127.33	154426.0
2012-01-04 07:30:00	SPY	ETF	127.36	127.42	127.2	127.31	352531.0
2012-01-04 08:00:00	SPY	ETF	127.34	127.6029	127.05	127.13	744678.0
2012-01-04 08:30:00	SPY	ETF	127.14	127.34	127.03	127.08	1107032.0
2012-01-04 09:00:00	SPY	ETF	127.08	127.22	127.06	127.2	1251994.0
2012-01-04 09:30:00	SPY	ETF	127.2	127.45	127.04	127.35	16933902.0
2012-01-04 10:00:00	SPY	ETF	127.35	127.36	126.86	126.93	12705379.0
2012-01-04 10:30:00	SPY	ETF	126.93	127.03	126.71	127.0	8938351.0
2012-01-04 11:00:00	SPY	ETF	127.0	127.2	126.98	127.15	6511789.0
2012-01-04 11:30:00	SPY	ETF	127.15	127.38	127.1	127.29	6581211.0
2012-01-04 12:00:00	SPY	ETF	127.29	127.62	127.27	127.58	5702038.0
2012-01-04 12:30:00	SPY	ETF	127.58	127.65	127.45	127.61	4149236.0
2012-01-04 13:00:00	SPY	ETF	127.61	127.61	127.35	127.43	5825570.0
2012-01-04 13:30:00	SPY	ETF	127.44	127.73	127.42	127.67	5203769.0
2012-01-04 14:00:00	SPY	ETF	127.68	127.69	127.45	127.59	6407229.0
2012-01-04 14:30:00	SPY	ETF	127.6	127.81	127.6	127.71	8485305.0
2012-01-04 15:00:00	SPY	ETF	127.71	127.71	127.52	127.62	7708034.0
2012-01-04 15:30:00	SPY	ETF	127.62	127.81	127.58	127.68	16372811.0
2012-01-04 16:00:00	SPY	ETF	127.65	127.79	126.97	127.75	9025675.0
2012-01-04 16:30:00	SPY	ETF	127.74	127.8	127.73	127.76	367459.0
2012-01-04 17:00:00	SPY	ETF	127.75	127.76	127.7	127.74	126482.0
2012-01-04 17:30:00	SPY	ETF	127.74	127.78	127.72	127.76	79542.0
2012-01-04 18:00:00	SPY	ETF	127.73	127.73	127.63	127.71	211188.0
2012-01-04 18:30:00	SPY	ETF	127.71	127.71	127.64	127.67	25425.0
2012-01-04 19:00:00	SPY	ETF	127.67	127.68	127.63	127.67	38732.0
2012-01-04 19:30:00	SPY	ETF	127.66	127.7	127.62	127.67	222446.0
2012-01-04 07:00:00	QQQ	ETF	56.84	56.96	56.84	56.92	4600.0
2012-01-04 07:30:00	QQQ	ETF	56.92	56.92	56.86	56.88	3200.0
2012-01-04 08:00:00	QQQ	ETF	56.9	56.9	56.76	56.8	109012.0
2012-01-04 08:30:00	QQQ	ETF	56.8	56.88	56.76	56.77	195706.0
2012-01-04 09:00:00	QQQ	ETF	56.77	56.82	56.76	56.8	308274.0
2012-01-04 09:30:00	QQQ	ETF	56.8	56.88	56.62	56.79	4291750.0
2012-01-04 10:00:00	QQQ	ETF	56.79	56.79	56.64	56.6899	2204651.0
2012-01-04 10:30:00	QQQ	ETF	56.677	56.79	56.56	56.76	2227253.0
2012-01-04 11:00:00	QQQ	ETF	56.76	56.95	56.75	56.9	1980202.0
2012-01-04 11:30:00	QQQ	ETF	56.9	57.015	56.7909	56.95	1355078.0
2012-01-04 12:00:00	QQQ	ETF	56.96	57.06	56.94	57.03	1690223.0
2012-01-04 12:30:00	QQQ	ETF	57.0385	57.13	57.0	57.11	1354254.0
2012-01-04 13:00:00	QQQ	ETF	57.119	57.119	56.98	57.05	1628796.0
2012-01-04 13:30:00	QQQ	ETF	57.05	57.17	57.04	57.13	990940.0
2012-01-04 14:00:00	QQQ	ETF	57.121	57.13	57.0	57.09	1548885.0
2012-01-04 14:30:00	QQQ	ETF	57.09	57.22	57.085	57.165	1840808.0
2012-01-04 15:00:00	QQQ	ETF	57.17	57.17	57.03	57.109	2127246.0
2012-01-04 15:30:00	QQQ	ETF	57.11	57.16	57.07	57.14	2774400.0
2012-01-04 16:00:00	QQQ	ETF	57.14	57.22	57.1132	57.19	862861.0

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

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