PREVIEW / etf_30min / 2009-11-11

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-11.parquet
  size:    235 KB
  rows:    7,821

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
2009-11-11 04:00:00	SPY	ETF	110.29	110.44	110.24	110.44	1350.0
2009-11-11 04:30:00	SPY	ETF	110.44	110.66	110.42	110.66	2050.0
2009-11-11 05:00:00	SPY	ETF	110.58	110.58	110.57	110.57	300.0
2009-11-11 05:30:00	SPY	ETF	110.48	110.48	110.42	110.43	2015.0
2009-11-11 06:00:00	SPY	ETF	110.48	110.48	110.43	110.44	4400.0
2009-11-11 06:30:00	SPY	ETF	110.42	110.6	110.41	110.52	19419.0
2009-11-11 07:00:00	SPY	ETF	110.52	110.62	110.48	110.51	169180.0
2009-11-11 07:30:00	SPY	ETF	110.54	110.54	110.39	110.4	381866.0
2009-11-11 08:00:00	SPY	ETF	110.57	110.57	110.35	110.37	624352.0
2009-11-11 08:30:00	SPY	ETF	110.37	110.43	110.33	110.35	860850.0
2009-11-11 09:00:00	SPY	ETF	110.35	110.41	110.3	110.3	744777.0
2009-11-11 09:30:00	SPY	ETF	110.31	110.46	110.03	110.41	18762259.0
2009-11-11 10:00:00	SPY	ETF	110.4	110.82	110.17	110.68	19854826.0
2009-11-11 10:30:00	SPY	ETF	110.68	110.695	109.865	110.06	22477965.0
2009-11-11 11:00:00	SPY	ETF	110.06	110.1	109.73	109.9675	17915181.0
2009-11-11 11:30:00	SPY	ETF	109.95	110.14	109.63	109.82	13025486.0
2009-11-11 12:00:00	SPY	ETF	109.82	110.04	109.75	110.04	7586127.0
2009-11-11 12:30:00	SPY	ETF	110.0399	110.24	109.93	109.9601	8537893.0
2009-11-11 13:00:00	SPY	ETF	109.97	110.16	109.93	109.97	5323551.0
2009-11-11 13:30:00	SPY	ETF	109.98	110.04	109.62	109.79	10679288.0
2009-11-11 14:00:00	SPY	ETF	109.79	110.02	109.74	109.93	7935447.0
2009-11-11 14:30:00	SPY	ETF	109.92	110.15	109.8917	110.07	5937565.0
2009-11-11 15:00:00	SPY	ETF	110.07	110.13	109.83	110.03	7014050.0
2009-11-11 15:30:00	SPY	ETF	110.02	110.18	109.93	110.13	16990701.0
2009-11-11 16:00:00	SPY	ETF	110.14	110.75	109.8	110.09	3459260.0
2009-11-11 16:30:00	SPY	ETF	110.09	110.15	110.05	110.07	308909.0
2009-11-11 17:00:00	SPY	ETF	110.08	110.14	110.04	110.07	87829.0
2009-11-11 17:30:00	SPY	ETF	110.12	110.18	110.1	110.17	192039.0
2009-11-11 18:00:00	SPY	ETF	110.13	110.17	110.11	110.11	76721.0
2009-11-11 18:30:00	SPY	ETF	110.12	110.13	110.06	110.13	32702.0
2009-11-11 19:00:00	SPY	ETF	110.16	110.2	110.15	110.2	15124.0
2009-11-11 19:30:00	SPY	ETF	110.2	110.28	110.2	110.25	25412.0
2009-11-11 04:00:00	QQQ	ETF	43.84	43.84	43.84	43.84	420.0
2009-11-11 04:30:00	QQQ	ETF	43.95	43.99	43.95	43.99	800.0
2009-11-11 05:00:00	QQQ	ETF	43.92	43.92	43.92	43.92	2500.0
2009-11-11 05:30:00	QQQ	ETF	43.95	43.95	43.95	43.95	2500.0
2009-11-11 06:00:00	QQQ	ETF	43.95	43.98	43.95	43.98	800.0
2009-11-11 06:30:00	QQQ	ETF	43.97	44.0	43.96	44.0	6000.0
2009-11-11 07:00:00	QQQ	ETF	44.0	44.05	44.0	44.0	114200.0
2009-11-11 07:30:00	QQQ	ETF	44.02	44.02	43.96	43.97	215947.0
2009-11-11 08:00:00	QQQ	ETF	43.97	43.98	43.94	43.95	441960.0
2009-11-11 08:30:00	QQQ	ETF	43.95	43.97	43.93	43.94	464943.0
2009-11-11 09:00:00	QQQ	ETF	43.93	43.96	43.91	43.94	553769.0
2009-11-11 09:30:00	QQQ	ETF	43.94	44.03	43.85	44.0	12014402.0
2009-11-11 10:00:00	QQQ	ETF	44.01	44.14	43.96	44.07	7482678.0
2009-11-11 10:30:00	QQQ	ETF	44.07	44.08	43.78	43.8	9546331.0
2009-11-11 11:00:00	QQQ	ETF	43.8	43.82	43.65	43.7801	7367752.0
2009-11-11 11:30:00	QQQ	ETF	43.79	43.87	43.68	43.73	5313513.0
2009-11-11 12:00:00	QQQ	ETF	43.73	43.8102	43.71	43.8101	3280079.0
2009-11-11 12:30:00	QQQ	ETF	43.82	43.88	43.75	43.76	4264797.0

> showing 50 of 7,821 rows — these rows as CSV

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