PREVIEW / etf_30min / 2012-01-11

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-11.parquet
  size:    280 KB
  rows:    9,555

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-11 04:30:00	SPY	ETF	129.17	129.22	129.17	129.22	1800.0
2012-01-11 05:00:00	SPY	ETF	129.1	129.1	129.1	129.1	1000.0
2012-01-11 05:30:00	SPY	ETF	129.07	129.07	129.07	129.07	400.0
2012-01-11 06:00:00	SPY	ETF	129.07	129.07	128.76	128.76	5500.0
2012-01-11 06:30:00	SPY	ETF	128.63	128.75	128.61	128.65	89550.0
2012-01-11 07:00:00	SPY	ETF	128.62	128.64	128.36	128.61	269545.0
2012-01-11 07:30:00	SPY	ETF	128.63	128.95	128.53	128.78	286618.0
2012-01-11 08:00:00	SPY	ETF	128.8	128.86	128.5	128.57	732414.0
2012-01-11 08:30:00	SPY	ETF	128.57	128.82	128.51	128.73	927452.0
2012-01-11 09:00:00	SPY	ETF	128.73	128.85	128.61	128.73	931213.0
2012-01-11 09:30:00	SPY	ETF	128.73	129.05	128.57	128.64	15563163.0
2012-01-11 10:00:00	SPY	ETF	128.63	128.94	128.52	128.8785	9681540.0
2012-01-11 10:30:00	SPY	ETF	128.87	129.13	128.78	128.781	10104820.0
2012-01-11 11:00:00	SPY	ETF	128.79	128.89	128.66	128.69	7468698.0
2012-01-11 11:30:00	SPY	ETF	128.7	129.03	128.69	128.86	6016204.0
2012-01-11 12:00:00	SPY	ETF	128.86	129.05	128.76	128.9195	5109714.0
2012-01-11 12:30:00	SPY	ETF	128.92	129.01	128.84	128.97	3059752.0
2012-01-11 13:00:00	SPY	ETF	128.97	129.11	128.95	129.11	3880715.0
2012-01-11 13:30:00	SPY	ETF	129.109	129.23	128.99	129.03	6361602.0
2012-01-11 14:00:00	SPY	ETF	129.03	129.11	128.85	128.95	7371100.0
2012-01-11 14:30:00	SPY	ETF	128.95	129.16	128.93	129.021	7039188.0
2012-01-11 15:00:00	SPY	ETF	129.02	129.37	129.0	129.35	9074061.0
2012-01-11 15:30:00	SPY	ETF	129.35	129.37	129.16	129.24	12033746.0
2012-01-11 16:00:00	SPY	ETF	129.25	129.32	129.2	129.25	2501561.0
2012-01-11 16:30:00	SPY	ETF	129.25	129.3	129.23	129.25	145246.0
2012-01-11 17:00:00	SPY	ETF	129.24	129.26	129.12	129.25	295025.0
2012-01-11 17:30:00	SPY	ETF	129.26	129.27	129.23	129.25	21590.0
2012-01-11 18:00:00	SPY	ETF	129.26	129.3	129.23	129.28	34572.0
2012-01-11 18:30:00	SPY	ETF	129.26	129.26	129.2	129.22	42669.0
2012-01-11 19:00:00	SPY	ETF	129.2	129.2	129.13	129.13	130050.0
2012-01-11 19:30:00	SPY	ETF	129.14	129.17	129.12	129.15	115953.0
2012-01-11 06:30:00	QQQ	ETF	57.9	57.9	57.86	57.87	7400.0
2012-01-11 07:00:00	QQQ	ETF	57.87	57.88	57.79	57.87	12028.0
2012-01-11 07:30:00	QQQ	ETF	57.87	58.0	57.87	57.97	89500.0
2012-01-11 08:00:00	QQQ	ETF	57.94	57.99	57.83	57.86	63591.0
2012-01-11 08:30:00	QQQ	ETF	57.85	58.0	57.85	57.97	330229.0
2012-01-11 09:00:00	QQQ	ETF	57.97	58.03	57.94	58.03	219376.0
2012-01-11 09:30:00	QQQ	ETF	58.02	58.175	57.87	57.88	4831950.0
2012-01-11 10:00:00	QQQ	ETF	57.88	58.15	57.81	58.1	3080867.0
2012-01-11 10:30:00	QQQ	ETF	58.1	58.2249	58.05	58.1	3425684.0
2012-01-11 11:00:00	QQQ	ETF	58.1	58.15	58.02	58.02	1809823.0
2012-01-11 11:30:00	QQQ	ETF	58.02	58.22	58.01	58.1129	1536877.0
2012-01-11 12:00:00	QQQ	ETF	58.12	58.17	58.05	58.09	1620629.0
2012-01-11 12:30:00	QQQ	ETF	58.1	58.14	58.07	58.1	2064235.0
2012-01-11 13:00:00	QQQ	ETF	58.11	58.175	58.1002	58.1671	1355049.0
2012-01-11 13:30:00	QQQ	ETF	58.17	58.24	58.05	58.0717	2143412.0
2012-01-11 14:00:00	QQQ	ETF	58.08	58.21	58.08	58.169	1781130.0
2012-01-11 14:30:00	QQQ	ETF	58.17	58.225	58.15	58.18	1515050.0
2012-01-11 15:00:00	QQQ	ETF	58.18	58.29	58.17	58.279	1485902.0
2012-01-11 15:30:00	QQQ	ETF	58.27	58.28	58.16	58.16	2747281.0

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

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